Answer Happy

Question 2 Contemporary Database Management System (DBMS) use different database models to keep track of entities, attributes, and relationships. The most popular type of DBMS today for PCs as well as for larger computers and mainframes is the relational DBMS. SUPPLIER Columns (Attributes, Hupplier Number Supplier Name Super Street Supplier City Starp 100 COM 74 Dayton CH 450 GU. MON 1997 Gandolyret Ord CH 40310 6 akaon Composiona Mchin Show LANG KY 5144 Bryant Corporation 4915 MIDI NY Rows Recorda, Tuples 11544 Key Field Primary keyl PART Part Nunow Part New 137 Doorwich 146 Side mir 150 Darmoking 100 Door lock 16 Cameror 170 Door hande Unil Prem Supplier Number 200 12.00 6144 4.00 1.00 1000 5400 701 10.00 200 Primary key Foreign Key (a) Based on the picture above, describe FIVE (5) ways how relational DBMS organizes data. (10 marks) (b) Build data hierarchy for student database based on the following criteria: i. Database: Course File, Personal File, Financial File ii. File: Personal File (Create five records) that consist Name, Student_ID, Years of Birth, Place of Birth and Race