QuestionQuestion

Part 1

1. What are the key features of a Database Management System? (list 5 features). Give examples of 3 DBMS systems you know.                    
Table 1 - File Structure for a Student database (Stud ID, Name, Address, School)
10342 Abraham Lincoln 123 Main St, Vienna VA 20121 Woodson H.S
12362 John Kennedy 678 Market St, Centreville VA 20121 Thomas jefferson H.S
26321 Bill Clinton 324 Water St, Manassas VA 22021 Woodson H.S
25903 Lyndon Johnson 459 Bay St, Fairfax VA 23123 Thomas Jefferson H.S
95321 Richard Nixon 321 Bank St, Lorton VA 23874 Woodson H.S
45123 John Adams 436 Pipe St, Warrenton VA 23145 TJHS

2. Given the file structure shown in Table-1, what problems would you encounter if you wanted to produce a listing of students by the city?

3. What data redundancies do you detect? How could these redundancies lead to anomalies?

4. Write 5 possible business rules each for the following two scenarios       
a. A trucking company
b. The White House

5. List a minimum of two data model components each (entities, attributes, relationships, constraints) for the following two scenarios    
a. Hospital
b. Airport

Part 2

6. Trucking Company: Using the business rules listed below, develop a database model for an application to track trucks, drivers and their driving assignments. You are encouraged to identify additional business rules and assumptions to help identify entities and attributes. State all such additional business rules and assumptions that you make. Use the Crow’s Foot notation. Clearly indicate primary keys, foreign keys, relationship type, relationship strengths, mandatory attributes, optional attributes and cardinalities.
a. The company owns multiple trucks
b. The company also rents trucks from multiple rental companies
c. The company operates trucks amongst multiple cities
d. Each route is assigned a primary driver and a backup driver
e. A truck owned by the company must be serviced after 50 trips

7. Hospital: Using the business rules listed below, develop a database model for an application to track doctors and patients at a hospital. You are encouraged to identify additional business rules and assumptions to help identify entities and attributes. State all such additional business rules and assumptions that you make. Use the Crow’s Foot notation. Clearly indicate primary keys, foreign keys, relationship type, relationship strengths, mandatory attributes, optional attributes and cardinalities.
a. The hospital employs multiple doctors
b. The hospital employs multiple nursing staff
c. A doctor can have multiple degrees but must have a minimum of one degree
d. A doctor can be a general physician or a specialist
e. A patient can be treated as in-patient or out-patient
f. In-patients are assigned hospital rooms.
g. Patient rooms can be of type: single, shared, suite
h. Out-patients are assigned beds
i. Each patient is assigned a primary nurse and a secondary nurse
j. Each patient is assigned a primary doctor.
k. A patient can be seen by multiple doctors

Solution PreviewSolution Preview

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.

Part I

1. Question 1
• What are the key features of a Database Management System? (list 5 features).
i. Distribution transparency
ii. Transaction transparency
iii. Failure transparency
iv. Performance transparency
v. Heterogeneity transparency
• Give examples of 3 DBMS systems you know.
i. Oracle
ii. Sql server             
iii. Mysql

2. Given the file structure shown in Table-1, what problems would you encounter if you wanted to produce a listing of students by the city?
• I need to parse Address field to get the city name. then I have to compare that name with other name in other address field
• It ask for too much time...
$60.00 for this solution

PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

Find A Tutor

View available Database Development Tutors

Get College Homework Help.

Are you sure you don't want to upload any files?

Fast tutor response requires as much info as possible.

Decision:
Upload a file
Continue without uploading

SUBMIT YOUR HOMEWORK
We couldn't find that subject.
Please select the best match from the list below.

We'll send you an email right away. If it's not in your inbox, check your spam folder.

  • 1
  • 2
  • 3
Live Chats