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 cach purchase. Table 1 is used to record all the data in the shop. Customer Customer Invoice Name Product Product Price $50 $67 Date Quantity ID No ID Helen Helen Helen Mary Davis Davis 001 N123 21/3/2022 3. P12 P13 21/3/2022 25/3/2022 28/3/2022 28/3/2022 28/3/2022 001 001 N123 N124 N125 N126 N126 Table 1: Happy Shop Database P12 $50 002 P14 $87 2. 003 P12 $50 3 003 PIS $26 (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 nomal form that Table 1 belongs to. Then, normalize Table I 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 cach purchase. Table 1 is used to record all the data in the shop. Customer Customer Invoice Name Product Product Price $50 $67 Date Quantity ID No ID Helen Helen Helen Mary Davis Davis 001 N123 21/3/2022 3. P12 P13 21/3/2022 25/3/2022 28/3/2022 28/3/2022 28/3/2022 001 001 N123 N124 N125 N126 N126 Table 1: Happy Shop Database P12 $50 002 P14 $87 2. 003 P12 $50 3 003 PIS $26 (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 nomal form that Table 1 belongs to. Then, normalize Table I to 3NF by showing the table schema for each table.
Database Systems: Design, Implementation, & Management
12th Edition
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Carlos Coronel, Steven Morris
Chapter7: Introduction To Structured Query Language (sql)
Section: Chapter Questions
Problem 97C: The following tables provide a very small portion of the data that will be kept in the database....
Related questions
Concept explainers
SQL
SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.
Queries
A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.
Question
Solve both part
Transcribed Image Text:Question A3
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 cach purchase. Table I is used to record all
the data in the shop.
Product Product
Price
Customer Customer Invoice
ID
001
001
001
002
Date
Quantity
Name
Helen
No
ID
21/3/2022
N123
N123
P12
$50
3.
Helen
Helen
21/3/2022
25/3/2022
28/3/2022
P13
P12
$67
$50
$87
N124
7
Mary
N125
P14
003
Davis
N126
28/3/2022
P12
$50
3.
N126
$26
28/3/2022
Table 1: Happy Shop Database
003
Davis
P15
6.
(a) Identify the primary key with minimum number of attributes of Table 1 and discuss
THREE different update anomalies in Table I with examples.
(b) State the nomal form that Table 1 belongs to. Then, normalize Table 1 to 3NF by showing
the table schema for each table.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage