1.
2.
3.
4.
The figure shows a conceptual ERD (CERD) for College Kenari Registration System, where four entities have been determined: TUTOR, COURSE, STUDENT, and OFFERING. COURSE TO OFFERING and TUTOR TO OFFERING are both 1.*, but STUDENT TO OFFERING is ** Tutor Course courseNo courseName course Description Has Taker 1..1 Offering courseNo tutorNo startDate startTime. endDate end Time maxStudents tutorNo 1.1 tutorName phoneNum Enrols fee Student matricNo studentFName student Name Street City Postcode telNo In order to develop the system, you were asked to design the Logical ERD based on the figure above. Identify the possible set of relation schemas for the figure: O A STUDENT (matricNo, studentName, studentlName, street, city, postcode, telNo) COURSE (courseNo, courseName, courseDescription) OFFERING (startDate, startTime, endDate, endTime, maxstudents) TUTOR (tutorNo, TutorName, phoneNum) B. STUDENT (matricNo, studentFName, student.Name, street, city, postcode, telNo) COURSE (courseNo, courseName, course Description) OFFERING (courseNo, tutorNo, startDate, startTime, endDate, endTime, maxStudents) TUTOR (tutorNo, TutorName, phoneNum) OC. STUDENT (matricNo, studentName, studentName, street, city, postcode, telNo) COURSE (courseNo, courseName, course Description) OFFERING (courseNo, tutorNo, startDate, startTime, endDate, endTime, maxStudents) TUTOR (tutorNo, TutorName, phoneNum) REGISTRATION (regid, fee, regDate) OD. STUDENT (matricno, studentName, student Name, street, city, postcode, telNo) COURSE (courseNo, courseName, course Description) OFFERING (courseNo, tutorno, startDate, startTime, endDate, endTime, maxstudents) TUTOR (tutorno, TutorName, phoneNum) REGISTRATION (regid, fee, regDate, courseNo, tutorNo, matricno) fTitle The table displays the details of the roles played by actors and actresses in films. filmNo dirNo director actorNo aName role F1100 Happy Days D101 Jim Alan A1020 Sheila Toner Jean Simson D101 Jim Alan A1222 Peter Watt Tom Kinder D101 Jim Alan A1020 Sheila Toner Silvia Simpson F1109 Snake Bite D076 Sue Ramsay A1567 Steven McDonald Tim Rosey D076 Sue Ramsay A1222 Peter Watt Archie Bold timeOnScreen 15.45 25.38 22.56 19.56 10.44 Describe why the table shown below is NOT in first normal form (INF)? 1. The details of actors and actresses are repeated for each film. II. There are multiple values in dirNo and director columns. III. A film has only one director. IV. filmNo should be removed from the table. O A. I and II O B. I and IV O C. II and III O D. III and IV This case study describes a company called StayHome, which rents out CD games to its members. The first branch of StayHome was established in 2002 in Johor Bahru but the company has now grown and has many branches throughout Malaysia The company's success is due to the first-class service it provides to its members and the wide and varied stock of games available for rent As StayHome has grown, so has the difficulties in managing the increasing amount of data used and generated by the company. To ensure the continued success of the company, the Director of StayHome has urgently requested that a database application be built to help solve the increasing problems of data management. One of the data requirements that you have identified is as follows: A customer of Stayhome must first register as a member of a local branch of StayHome. The details held on a member are member number, name, address, and the date that the member registered at a branch. For each CD game, the details held on each CD are the CD number, title, number of the CD available in each store, and daily rental rate. The rental number is unique throughout the company. Each member is allowed to rent more than one CD games, where a rental number, date rented and return date to return is CD will be created every time a member came to rent a CD. The CD game is also available to be rented by many members as StayHome have a number of games with the same title. Based on the case study, which of the following BEST describe the Logical ERD for the above statement? . MEMBER 1.. member num member_name member address reg_date CD_GAME CD number game title num of game rental rate OB MEMBER member num member_name member address reg_date RENTAL rental_num rent_date 1. return_date member num CD_number CD_GAME CD_number game_title num_of game rental_rate MEMBER how RENTAL rental_num rent_date return_date 1.1 member num member_name member_address rer date 1. CD_GAME CD_number game title num of game rental_rate OD MEMBER w member num member name member address rer date CD_GAME CD number game_title num of game rental_rate rentalnum rent date return_date Consider the following table. StudentName Yap Xiao Ying Lim Shi Jia Wee Zhi Shan Clarice Yong Hue Mee Muhammad Hafizul Amin Bin Hadri Thravpathiyan a/l Ragunathan Glenn Yoong Teck Chern Yap Kai Yun Low Jin Lu Studenti 2001188923 2001472445 2001447184 2000138298 2001188948 2001188955 2001386313 2000143011 2001188962 ProjectField Multimedia Multimedia Networking Programming Database Application Application Database Computing Supervisor Johan bin Adnan Yahya bin Majid Tan Ai Lin Mazni binti Omar Johan bin Adnan Tan Ai Lin Johan bin Adnan Shalina binti Ismail Shalina binti Ismail Insert following new project supervision information in the table above. (Ali, 2001188918). O A. INSERT INTO Projectsupervision VALUES (NULL, NULL, Ali, 2001188918), OB.INSERT INTO ProjectSupervision (StudentName, Studenti, ProjectField, Supervisor) VALUES (Ali, 2001188918, o, 0); OC.INSERT INTO Projectsupervision (StudentName, Studenti, ProjectField, Supervisor) VALUES (Ali, 2001188918, NULL, NULL); OD. INSERT INTO ProjectSupervision VALUES (Al, 2001188918, NULL, NULL)
