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.

Fundamentals of Information Systems
Fundamentals of Information Systems
8th Edition
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Ralph Stair, George Reynolds
Chapter3: Database Systems And Applications
Section: Chapter Questions
Problem 2.1CTQ
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.
Similar questions
Recommended textbooks for you
Fundamentals of Information Systems
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
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
SEE MORE TEXTBOOKS