- Question 1 15 Marks Given The Relational Design Of A Database Department Deptcode Deptname Course Crscode Crstit 1 (87.72 KiB) Viewed 64 times
- Question 1 15 Marks Given The Relational Design Of A Database Department Deptcode Deptname Course Crscode Crstit 2 (173.99 KiB) Viewed 64 times
- Question 1 15 Marks Given The Relational Design Of A Database Department Deptcode Deptname Course Crscode Crstit 3 (43.43 KiB) Viewed 64 times
- Question 1 15 Marks Given The Relational Design Of A Database Department Deptcode Deptname Course Crscode Crstit 4 (148.69 KiB) Viewed 64 times
- Question 1 15 Marks Given The Relational Design Of A Database Department Deptcode Deptname Course Crscode Crstit 5 (27.24 KiB) Viewed 64 times
QUESTION 1 (15 marks) Given the relational design of a database. DEPARTMENT (DeptCode, DeptName) COURSE (CrsCode, CrsTitle, CrsDescription, CrsCredit, DeptCode) CLASS (ClassCode, Class Section, Class Time, CrsCode, Room Code) ROOM (Room Code, Room Type) i) Identify the primary key(s) for each table. (4 marks) ii) Identify the foreign key(s). (3 marks) 1
iii) Propose 2 business rules. Show your answer in relational diagram. (4 marks) iv) Propose 2 business rules. Show your answer in relational schema. (4 marks) QUESTION 2 (17 marks) Based on the following tables, answer all questions: - STAFF Staff_ID 88563 88655 56238 54265 64892 Staff_Name Nurul Mardiha Muhammad Adam Abdul Rahman Nur Fateha Abdul Qayyum Staff_Address Taman Cempaka Sari Taman Cempaka Indah Kampung Batu Hampar Taman Cempaka Sari Taman Merdeka Jaya Department Code A502 A502 A512 B625 A512 DEPARTMENT Department Code A502 A512 B625 B630 Department_Name Administration Treasury Faculty of Science Faculty of Health 2
i) Identify the relationship type for both tables. (2 marks) ii) Integrity rule is a mandatory in database design and implementation. Please suggest how it can be implemented for the tables. (6 marks) iii) Identify the primary key and foreign key from the diagram. (2 marks) iv) Create relational diagram from the diagram. (2 marks) v) Create relational schema from the diagram. (2 marks) 3
vi) Do the tables show referential integrity? Give 1 (ONE) reason. (3 marks) QUESTION 3 (13 marks) Based on given information answer all questions: - STUDENT STU_ID STU_NAME PROGRAM 123 124 125 Nurul hasanah bt Hassan Mohd Ali bin Abu Siti Salwa bt Saleh Bachelor in IT Bachelor in Multimedia Bachelor in Software Engineering SPONSOR SP_CODE SP_NAME ADDRESS 01 02 03 MARA JPA TM Bangunan MARA, Shah Alam Kompleks JPA, Putra Jaya Menara Rebung, Bangsar SCHOLARSHIP SC_NUM SC_NAME AMOUNT 111 112 113 114 115 MARA scholarship Biasiswa kecil Persekutuan PTPTN SLAB Petronas Scholarship RM 5,000 RM700 RM6,500 RM 10.000 RM 7000 GRANT STU_ID SP_CODE SC_NUM BANK 123 124 125 125 01 03 02 02 111 115 112 114 BIMB MAY BANK BSN BSN 4.
i) List all the primary keys from each table. (2 marks) ii) List all foreign keys in the database (1 mark) iii) Draw your ERD for the database. (10 marks) 5