Design a new database with a minimum of 6 tables. Include appropriate constraints to create the tables. ● Your database MUST CONTAIN at least 6 (or more) TABLES! ● . . . An ERD or updated ERD. At least two tables should use a sequence to generate primary key values. Produce a database script file (.sql) that will create the database. Produce a script file to add data to the database. Produce a script file with 15 queries: At least four using join • At least three using where clause - At least three using order by At least two using single row functions • At least two using group by and group functions at least one nested query Atleast 4 queries from chapter 1 - 6 (exclude Create Table, insert queries)
Design a new database with a minimum of 6 tables. Include appropriate constraints to create the tables. ● Your database MUST CONTAIN at least 6 (or more) TABLES! ● . . . An ERD or updated ERD. At least two tables should use a sequence to generate primary key values. Produce a database script file (.sql) that will create the database. Produce a script file to add data to the database. Produce a script file with 15 queries: At least four using join • At least three using where clause - At least three using order by At least two using single row functions • At least two using group by and group functions at least one nested query Atleast 4 queries from chapter 1 - 6 (exclude Create Table, insert queries)
Chapter2: Database Design Fundamentals
Section: Chapter Questions
Problem 5TD
Related questions
Question
100%
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 7 images
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
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr