Happy Shop sells different products to the customers. A customer could buy one or more products at a time. An invoice will be issued to a customer for each purchase. Table 1 is used to record all the data in the shop. Customer Customer Date Product Product Quantity Invoice No ID Name ID Price 001 Helen N123 21/3/2022 P12 $50 3 001 Helen N123 21/3/2022 P13 $67 5 001 Helen N124 25/3/2022 P12 $50 7 002 Mary N125 28/3/2022 P14 $87 2 003 Davis N126 28/3/2022 P12 $50 3 003 Davis N126 28/3/2022 P15 $26 6 Table 1: Happy Shop Database (a) Identify the primary key with minimum number of attributes of Table 1 and discuss THREE different update anomalies in Table 1 with examples. (b) State the normal form that Table I belongs to. Then, normalize Table 1 to 3NF by showing the table schema for each table.

Happy Shop sells different products to the customers. A customer could buy one or more products at a time. An invoice will be issued to a customer for each purchase. Table 1 is used to record all the data in the shop. Customer Customer Date Product Product Quantity Invoice No ID Name ID Price 001 Helen N123 21/3/2022 P12 $50 3 001 Helen N123 21/3/2022 P13 $67 5 001 Helen N124 25/3/2022 P12 $50 7 002 Mary N125 28/3/2022 P14 $87 2 003 Davis N126 28/3/2022 P12 $50 3 003 Davis N126 28/3/2022 P15 $26 6 Table 1: Happy Shop Database (a) Identify the primary key with minimum number of attributes of Table 1 and discuss THREE different update anomalies in Table 1 with examples. (b) State the normal form that Table I belongs to. Then, normalize Table 1 to 3NF by showing the table schema for each table.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

ote: Answer only two questions. Was er all brandnas (arks each brana) MATLab A) Write a command to get the sine value of the angle (60°)? B) If you have (4x4) matrix which command you use to delete the third row? C) For the system shown bellow which command use to get (y)? h X-
Question4: [F A. For the script file below: X 0: for i = 1:1000 for j = 1:2000 if i == j
How do "file signatures" and "magic numbers" assist in identifying file types and formats, and how are they employed in software applications?
The first three values are correct. Please fill in the blanks and ensure that it answers the questions. Please don't copy and paste this is asking something different. Thank you
The easiest technique to update a file's string content is what?
Please define the following file extensions: .stl and .gcode
Why is it vital to make sure that a file is designed correctly? What difference does it make whether you know how the data in your text file is arranged if you already have it?
Computer science What is a file's read position? Where is the read position when a file is first opened for reading?
Explain the three main file structure approaches.
Storing data in a file can help the permanent storage of data. While trying to enter data in multiple lines program terminates on \n°. Explain with the help of a code how will you read and write the data in a file in multiple lines.
Describe three kinds of file structure.
The Master file mainly contains data that is unchangeable.