Question: normalisation to 3nf. Illustrate a crow's foot ERD notation Jadual/ Table 1 : LUNCHEON Sample Value Attribute Name MEMBER NUM MEMBER NAME MEMBER ADDRESS 214

normalisation to 3nf. Illustrate a crow's foot ERD notation

Jadual/ Table 1 : LUNCHEON Sample Value Attribute Name MEMBER NUM MEMBER NAME MEMBER ADDRESS 214 Sample Value 235 Asni Tahir UCA3, Sepangar, 84000 Sample Value 214 Chin Pel Yee The Light Residences, 83000, Nosoon Hungab 3-Dec-1985 0109826556 8 23-Dec-2020 27-Dec-2020 Yes LU5 15-Jan-2021 Glowing sea delight EN3 Salmon, rice, and soup MEMBER DOB MEMBER HP INVITE NUM INVITE DATE INVITE ACCEPT INVITE ATTEND LUNCH CODE LUNCH DATE LUNCH DESCRIPTION ENTREE CODE ENTREE DESCRIPTION 21-June-1980 0123031234 9 24-Dec-2020 28-Dec-2020 Yes LU5 15-Jan-2021 Glowing sea delight EN3 Salmon, rice, and soup Suraya Allas Inanam Condominium, Inanam, 82304 10-May-1982 0164423333 10 25-Dec-2020 27-Dec-2020 No LUZ 12-Mar-2021 Ranch Superb EN5 Marinated steak, baked potato, and salad. RM42.90 DE2 Apple ple RM7.90 ENTREE_PRICE DESSERT CODE DESSERT DESCRIPTION DESSERT PRICE RM35.90 DE4 Chocolate mousse RM8.90 RM35.90 DE5 Cheese cake RM9.90 a) Kenalpasti dan tunjukkan proses normalisasi ke atas Jadual 1 LUNCHEON kepada Third Normal Form (3NF). Tuliskan skema relational bagi semua jadual yang telah dinormalisasikan, dengan menyatakan kekunci utama dan kekunci asing. Identify and demonstrate the normalisation process for the Table 1 LUNCHEON to Third Normal Form (3NF). Write the relational schema of the normalised tables, indicating the primary and foreign keys. 32 (18 markah/marks) b) Ilustrasikan gambarajah ERD notasi Crow's Foot menggunakan jawapan anda di (a). Illustrate a Crow's Foot ERD notation using your result in (a). (12 markah/marks)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

7. Suppose you are given the following business rules to form the basis for a database design. The database must enable the manager of a company dinner club to mail invitations to the club's members,...

Suppose you are given the following business rules to form the basis for a database design. The database must enable the manager of a company dinner club to mail invitations to the club's members, to...

How to perform normalisation on these documents? Building Insurance and Damage History Property ID 4231212 Bulding ID 1 Bulding Size (sq. m) 300 Bulding Class* 1 LGA Building Value $523,000 Insurance...

Building Damage Assessment Visit Report Property ID 4231212 Property Address Street 69 Wide Rd Town West Forrest Postcode 3123 LGA Code 45 LGA Name Wardinia Building ID LGA Building Value Building...

when a customer makes a booking in person or over the phone, the clerk will first check if the customer's details are registered (some customers have pre-registered their details to make dealing with...

In developing your final logical data model, composite attributes present on your conceptual model must be expanded into their component simple attributes, unless otherwise directed. If the...

Perform normalisation to 3NF for the data depicted in the sample documents. Note that only one normalisation is required for the function room evaluation, you have been provided with two samples so...

3. (c) The table shown in Figure 14.23 is susceptible to update anomalies. Provide examples of how insertion, deletion, and modification anomalies could occur on this table. applying normalisation to...

SECTION A: Answer ALL (30 marks) QUESTION 1 Rajesh owns a car rental shop. To maintain the rental records in a systematic way, Rajesh assigns a unique ID to each of his customers. He allows each...

Please come up with the database report based on Aged care facility management scenario with atleast 1 2 enties, Design your ER Diagram with all entity names, attribute names, primary and foreign...

An electron with a velocity of 10.0 m/s in the positive y -direction enters a region where there is a uniform electric field of 200 V/m in the positive x -direction. What are the x-and y-components...

Q.5)(5 Marks) An object moves under the influence of a central force given by F(r) = k/ r". If the object 's orbit is circular and passes through the force center, show that n= %3D 5. Answer to...

The annual percentage rate ( APR ) on a single - payment loan of S 1 , 0 0 0 at a simple interest rate of 1 2 % is: 1 2 % . 1 0 % . 2 4 % . 1 8 % 1 5 % .

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

KEY QUESTION What is the basic determinant of ( a ) the transactions demand and ( b ) the asset demand for money? Explain how these two demands can be combined graphically to determine total money...

KEY QUESTION Assume that the following data characterize a hypothetical economy: money supply $200 billion; quantity of money demanded for transactions $150 billion; quantity of money demanded as...

Suppose that the Federal funds rate is 4 percent and real GDP falls 2 percent below potential GDP. Acording to the Taylor rule, in what direction and by how much should the Fed change the Federal...