Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

LIVILIVIT CUCUG Question 1 Not yet answered Marked out of 100 Flag question Abdulla is a manager of a confectionary company that provides food students

image text in transcribed
LIVILIVIT CUCUG Question 1 Not yet answered Marked out of 100 Flag question Abdulla is a manager of a confectionary company that provides food students in xyz company. He would like to have an information system that will help him track the students taking meals from different canteens. Since Abdulla is not an IS expert, the table below is used to store the information. As a student can take many meals and a student will not attend more than 1 meal of the same date. The primary key of the following table is Student Number + Meal Num. Students can have many foods for every meal Brg1 Student Num student Name Member Address Meal Num Meal Date Venue Code Venue Description Food Code Food Description 201810087 Abdulla Ahmed Dibba, Fujaira D0001 2-15-2020 Cale1 Mens Cafeteria Beef Burger Soft Coke Regular 201810095 Aisha Sohaib Merashid, Fujairah D0002 2-15-2020 Cafe2 Ladies Cafeteria Cak1 Chocolate Moist Hott Cafe Latte Q1. Normalize the relation until the 3" Normal form (2.5 Marks) Q2. Draw an ERD for the above Database using ER-Assistant software 2.5 marks]

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions