Objective: Create a database from scratch using the 2-step process 1) Information-level design and 2) Physical-level...

Transcribed Image Text:

Objective: Create a database from scratch using the 2-step process 1) Information-level design and 2) Physical-level design. The database must have a purpose and a general theme. Choosing a Topic: . Create a fake company or organization and create a database that could be used in some capacity at the company.. Avoid implementing an inventory system or some kind of sale system that deals with inventory. Instructions: 1. Your database must include the necessary tables, integrity constraints, forms, SQL statements and reports 2. Steps for implementing the database: 1. Information-level design: Work on data modeling, come up with a purpose for the database. Finalize a cumulative design which includes the table shorthand, functional dependencies, and an E-R diagram with entities and relationships. 2. Physical-level design: Create the database with tables, columns, integrity constraints (entity, referential, legal-values), forms, data, and reports. Objective: Create a database from scratch using the 2-step process 1) Information-level design and 2) Physical-level design. The database must have a purpose and a general theme. Choosing a Topic: . Create a fake company or organization and create a database that could be used in some capacity at the company.. Avoid implementing an inventory system or some kind of sale system that deals with inventory. Instructions: 1. Your database must include the necessary tables, integrity constraints, forms, SQL statements and reports 2. Steps for implementing the database: 1. Information-level design: Work on data modeling, come up with a purpose for the database. Finalize a cumulative design which includes the table shorthand, functional dependencies, and an E-R diagram with entities and relationships. 2. Physical-level design: Create the database with tables, columns, integrity constraints (entity, referential, legal-values), forms, data, and reports.