Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
2. Do the tables exhibit entity integrity? Answer yes or no and then explain your answer.

2. Do the tables exhibit entity integrity? Answer yes or no and then explain your answer.

Database System Concepts
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
icon
Related questions
Question

Can you help me with this study guide? My teacher will not respond to anything about it.

2. Do the tables exhibit entity integrity? Answer yes or no and then explain your answer. а. 3. Do the tables exhibit referential integrity? Answer yes or no and then explain your answer. Write NA (Not Applicable) if the table does not have a foreign key. а. 4. Identify the TRUCK table's candidate key(s). а. 5. Create the ERD for this database. а. 6. Create the relational diagram for this database. а. E.g. of an relational diagram is as follows: You will have Entity and all its attributes listed like below and also the relationship between them is depicted. You are only including the Primary Key, and other attributes for each entity. Entity attribate Figure Q3.13 The Ch03_VendingCo database tables Database name: Ch03_VendingCo Table name: BOOTH Table name: MACHINE BOOTH_PRODUCT BOOTH_PRICE Chips Cola Energy Drink MACHINE PRODUCT MACHINE PRICE Chips Chocolate Bar Energy Drink 1.5 1.25 1.25
Transcribed Image Text:2. Do the tables exhibit entity integrity? Answer yes or no and then explain your answer. а. 3. Do the tables exhibit referential integrity? Answer yes or no and then explain your answer. Write NA (Not Applicable) if the table does not have a foreign key. а. 4. Identify the TRUCK table's candidate key(s). а. 5. Create the ERD for this database. а. 6. Create the relational diagram for this database. а. E.g. of an relational diagram is as follows: You will have Entity and all its attributes listed like below and also the relationship between them is depicted. You are only including the Primary Key, and other attributes for each entity. Entity attribate Figure Q3.13 The Ch03_VendingCo database tables Database name: Ch03_VendingCo Table name: BOOTH Table name: MACHINE BOOTH_PRODUCT BOOTH_PRICE Chips Cola Energy Drink MACHINE PRODUCT MACHINE PRICE Chips Chocolate Bar Energy Drink 1.5 1.25 1.25
Answer the following questions based upon Figure Q3.13 1) BOOTH U MACHINE (2 pts) (here we are doing UNION) 2) MACHINE U BOOTH (2 pts) (here we are doing UNION) 3) BOOTH N MACHINE (2 pts) (here we are doing INTERSECT) 4) MACHINE N BOOTH (here we are doing INTERSECT) 5) BOOTH DIFFERENCE MACHINE 6) MACHINE DIFFERENCE BOOTH Explain how MANY-TO-MANY relationship is implemented in the database. Define the following with an example. If example is missing then only half-credit will be given. Primary Key, Super Key, Candidate Key, Foreign Key, Secondary Key
Transcribed Image Text:Answer the following questions based upon Figure Q3.13 1) BOOTH U MACHINE (2 pts) (here we are doing UNION) 2) MACHINE U BOOTH (2 pts) (here we are doing UNION) 3) BOOTH N MACHINE (2 pts) (here we are doing INTERSECT) 4) MACHINE N BOOTH (here we are doing INTERSECT) 5) BOOTH DIFFERENCE MACHINE 6) MACHINE DIFFERENCE BOOTH Explain how MANY-TO-MANY relationship is implemented in the database. Define the following with an example. If example is missing then only half-credit will be given. Primary Key, Super Key, Candidate Key, Foreign Key, Secondary Key
Expert Solution
Step 1

Note : As per guidelines, we are authorized to answer only 1 question per post. Please repost other questions individually.

Solution for q.no 2 is in next step.

 

trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Troubleshooting
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 System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS