Answered step by step
Verified Expert Solution
Link Copied!

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

image

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Systems Design Implementation and Management

Authors: Carlos Coronel, Steven Morris

11th edition

9781305323230, 1285196147, 1305323238, 978-1285196145

More Books

Students also viewed these Databases questions

Question

Should you create an index on EMP_DOB? Why or why not?

Answered: 1 week ago

Question

What is a composite entity, and when is it used?

Answered: 1 week ago