Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question 1 A) Give 5 different case study tables (e.g 1. University, online shopping, vending machine etc) and mention the following detail about each relation.
Question 1 A) Give 5 different case study tables (e.g 1. University, online shopping, vending machine etc) and mention the following detail about each relation. 1. Super Key 2. Candidate Keys 3. Composite Key 4. Primary Key (PK) 5. Alternate Keys 6. Surrogate Key 7. Secondary Key, Sort Key 8. Foreign Key (FK) 9. Non-key attribute B) Write SQL commands in order to create the above database examples. Question 2 Give 5 different example of each type or relation i.e (Base relation, Query result , views)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started