Database Data Modeling

Part A

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 trucking company
• The White House

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

• Hospital
• Airport