Your business must meet the following requirements: It must have 2 or more master or parent tables It must have 3 or more child or transaction tables The project will include the following elements for the chosen business. 1. Introduction and Overview of the database 2. Identify the business rules of this business as it applies to the data 3. Create an Entity Relationship Diagram in crow’s feet notation. 4. Create a relational diagram using a 3 column crow’s feet diagram. Make sure you include all primary and foreign keys and data types on all columns. 5. Create a table in the lab document to identify the primary key for each entity. 6. Explain and apply the integrity rules for each entity. 7. Use a table in the lab document to define the relationships between each entity. Make sure you list the cardinality of the relationships. 8. Create the database in SQLite. 9. Show SQL statements for each table creation. 10. Highlight in your SQL statements where you assigned keys to each table, or show the SQL statements that assign keys to each table. 11. Highlight in your SQL statements where you establish any foreign keys, or show the SQL statements for each foreign key establishment. 12. Populate the database with at least 5 records in each table, and show the SQL statements used to populate the database.
For this project you will choose a business or use the previously chosen business to design a
stages.
Your business must meet the following requirements:
It must have 2 or more master or parent tables
It must have 3 or more child or transaction tables
The project will include the following elements for the chosen business.
1. Introduction and Overview of the database
2. Identify the business rules of this business as it applies to the data
3. Create an Entity Relationship Diagram in crow’s feet notation.
4. Create a relational diagram using a 3 column crow’s feet diagram. Make sure you include all primary and foreign
keys and data types on all columns.
5. Create a table in the lab document to identify the primary key for each entity.
6. Explain and apply the integrity rules for each entity.
7. Use a table in the lab document to define the relationships between each entity. Make sure you list the
cardinality of the relationships.
8. Create the database in SQLite.
9. Show SQL statements for each table creation.
10. Highlight in your SQL statements where you assigned keys to each table, or show the SQL statements that assign
keys to each table.
11. Highlight in your SQL statements where you establish any foreign keys, or show the SQL statements for each
foreign key establishment.
12. Populate the database with at least 5 records in each table, and show the SQL statements used to populate the
database.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 7 images
