AIA needs to keep track of information about the vehicles for Infinity Design

Aia needs to keep track of information about the

This preview shows page 3 - 8 out of 12 pages.

AIA needs to keep track of information about the vehicles for Infinity Design Solution Sdn Bhd. They need to store information of customer, car and accident. Customer information including LicenseNo, Name, and Address. Customer can own one or more cars, where the car information including PlateNo, Model and Year. A car not involved or involved in many accidents. If the car is involved in an accident, the information need to be aware is ReportNo, Location and Date. INSTRUCTION: Answer the entire questions below.
Image of page 3
DFC 20123 DATABASE DESIGN Page 30 of 60 2. Draw the E-R Diagram using Crow’s Foot Model based on the Activity4B
Image of page 4
DFC 20123 DATABASE DESIGN Page 31 of 60 Activity 4C Activity Outcome: Convert a given ERD into relational tables. 1. Convert the E-R Diagram based on the Activity 4A into the relational tables. 2. Convert the E-R Diagram based on the Activity 4B into the relational tables.
Image of page 5
DFC 20123 DATABASE DESIGN LAB ACTIVITY 4: Entity Relationship (ER) Model & Normalization – Part 2 Duration: 4 Hours Learning Outcomes This activity encompasses activities 4D and 4E At the end of this activity session, you should be able to: 1. Design E-R Diagram based on a given scenario by using Chen’s Model and Crow’Foot Activity 4D Activity outcome: Using Chen Model Notation, Draw the ERD for the given scenario below. There are many soccer teams in Liga Super Malaysia ; each team has an ID,name,main stadium, and which city this team belongs.Each team has many players,and each player belongs to one team.Each player has a number,name,DOB,start year and shirt number that he uses.Teams play matches, for each match you need to keep track the date on which the game is played, match ID and the final result of the match.Each match has exactly three referees.For each referee have an referee ID,name,DOB and year of experience. (10 Marks)
Image of page 6
DFC 20123 DATABASE DESIGN Page 33 of 60 Activity 4E Activity outcome: Using Crow’s Foot Model Notation, Draw the ERD for the given scenario below. Seremban Hospital has several wards. This hospital has a few types of ward depends on types of patients. Patient information will be recorded into file that patient number, patient name, address, phone number, IC number, patient and group of blood patient. Each patient is treated by a doctor at one time but one doctor can treats a number of patients. The information of doctors recorded are: doctor ID, doctor name, address, phone no, IC no and expertise. The nurses will be assigned to take care of the patients. Nurses in this hospital are graded based on their experience, qualification and duration of working in the hospital.
Image of page 7
Image of page 8

You've reached the end of your free preview.

Want to read all 12 pages?

  • Spring '20
  • Relational model, Database normalization, Infinity Design Solution Sdn, Success Software Co.

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes
A+ icon
Ask Expert Tutors