Case Study about Databases


Question 1

A database management system would help Dream house organize theirdata in a systematic way. It will also enable the firm to retrieveinformation in an easy and timely manner. Moreover, the database willenhance registration of new clients and updating of existing clientinformation.

Dream house is a huge business with numerous staff and employeeregistration form and information need to be represented in adatabase. Besides, property owners, potential client, and existingclients’ information also require database presentation (Aveyard,Phillips, &amp Paton, 2013). What is more, it is alsonecessary to database properties available for rent. The above datais related since the property owners’ details and client detailsneed to be documented for reference purpose. The queries that need tobe addressed may include the start up cost of creating the databaseand the expertise required to operate the system.

Question 2

Database management system would help WellmeadowsHospital maintain records and data in a proper and organized manner. The hospital maintains numerous categories of data that include staffinformation, patient information, and supplies information (Aveyard,Phillips, &amp Paton, 2013).All these data would be properly and easily updated, retrieved, andkept in a database thus would require presentation in a databasesystem. The quantity of supplies in the facility is directly relatedto the number of patients served at the hospital.

Question 3

There are four main database vendors globally, which offer greatdatabase management systems (DBMS). These include Oracle, MicrosoftAccess, IBM DB2, and MySQL. Their functionalities are diverse, butthey all share some function features. One of the most commonfeatures is cross-platform support. For example, the Oracle DBMS andIBM DB2 allow generic connectivity for connecting to non-oraclesystems, which enhances its functionality as one is not restricted toonly one type of DBMS. In addition, they all permit standard SQL forindexing, searching, and analyzing documents or text that is storedin the databases.

Data losses can prove to be quite a headache, and that is why mostof the DBMS offer recovery managers to backup, recover and restoredatabases in case of some disaster. Replication Support is a commonfunctionality spread out among the major database management systems.For example, the IBM D2 and MySQL offer homogeneous replication whichis a handy tool. Additionally, it is common to find the DBMS having agraphical user interface (GUI) or a command-line extension fordatabase manipulation. For example, Microsoft Access has a desktopapplication and allows the use of macros MySQL has aweb-based-browser GUI as well as a command-line interface.

Other common features available in the DBMS are data consolidation,statistical tools such as performance schema in MySQL and OracleGraph, Label-Based Access Control (LBAC), table partitioning,database partitioning and full-text indexing and searching (Aveyard,Phillips, &amp Paton, 2013). However, a company wouldbe better off using the Oracle DBMS due to its more powerful featuressuch as SQL Loaders, Data Access Components, and Database ResourceManagement (DRM), among others.

Question 4

Web services are used to enhance communication between two or moreelectronic devices. Technologies that are used in web service includeHttp that was designed for human to machine communication. They alsouse SOAP (SimpleObject Access Protocol) and FTP technologies. All webservice technologies are related in that they provide a reliableplatform to transmit information.

Question 5

Service-oriented architecture(SOA) is a software design where services are provided to otherapplication components through transmission protocol over a network(Aveyard, Phillips, &amp Paton, 2013).

Features of SOA

  • It is reusable-services can be used by multiple processes.

  • Standard based-the SOA services are built and described using prescribed standards for example WSDL (web services definition language)

  • They are discoverable, and location independent-the services are located via a service catalog and accessed through universal resource locators.

  • They are independent units of business functionality –each service provides a business role, which is independent.

  • Contract based policies and interface are described by an interface specification.

  • Loosely coupled-the service contracts are designed to be independent.

  • Message monitoring-SOA enables monitoring of information and can provide security attack detection.

Question 6

In the client/server architecture, the application and the databaseare split into two: a back-end (server) and a front-end (client)portion. The client operates the application and interacts with theuser, while the server handles the functions necessary for concurrentand shared data access to databases. All the DBMS, including Oracle,Microsoft, and IBM DB2, use a client-server architecture.

Web services enable applications to interact with one another on theweb, regardless of the language, platform or data formats. OracleDBMS can access web services via Java classes and PL/SQL packages inthe database(Aveyard, Phillips, &amp Paton, 2013).&nbspMicrosoft Access lets a user link to external data available via aweb service by simply creating a web service data connection that isprovided in the application. With the IBM DB2, a web services clientapplication can simply access the database via a WSDL interface.

Service oriented architecture (SOA) is an approach that is used tocreate an architectural design which is based on the use of services(such as RESTful web services), which carry out little functions likevalidating customers, producing data, or providing simple analyticaldata. The Oracle SOA Suite helps system developers create and manageservices for orchestrating into composite applications and businessprocesses. In addition, Microsoft Access and IBM DB2 acts as aservice provider and allows SQL applications to use web services.


Aveyard, D.C., Phillips, J. G., &amp Paton, D. J. (2013).&nbspU.S.Patent No. 8,539,507.Washington, DC: U.S. Patent and Trademark Office.