apply sql concepts to create a functional database appropriate for a small business hobby

Apply SQL concepts to create a functional database appropriate for a small business/hobby.
Part 1: Create Table diagram from ERD
– The database will have between 5 and 7 related entities.
Part 2: Write and run scripts to create tables and define constraints.
– All tables will have PK/FK defined
Part 3: Insert sample data
– At least 5 records should exist in each table.
Part 4: Test database
Part 5: Write questions and answer queries to exercise each one of the following concepts:

Sorting data and Restricting Rows (Ch 8)
Joining Data (Ch 9)
Single-row functions (Ch 10)
Group functions (Ch 11)
Subqueries (Ch 12)

Part 6: Prepare a final project presentation
Part 7: Present your Final Project (5-7 minutes)

Present your business and the ER diagram, explain relationships between tables and all constraints.

Part 8: Turn in the project, include the ER diagram, the presentation, and script(s) to create the DB and the queries from Part 5.
 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!Use Discount Code “Newclient” for a 15% Discount!NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

"Is this question part of your assignment? We will write the assignment for you. click order now and get up to 40% Discount"