Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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.
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