Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

[ 1 5 pts ] Describe the project in plain English and describe the business rules required. [ 2 0 pts ] Model the system

[15 pts] Describe the project in plain English and describe the business rules required.
[20 pts] Model the system with a crows feet entity relationship diagram
Conceptual model
Create a logical model (fully normalized)
Create a physical model (data types, primary/foreign keys)
Implement the model (Using Microsoft Access)
[10 pts] Create tables from your physical model.
[15 pts] Create appropriate relational schema and queries.
[10 pts] Enter some data
[15 pts] Report some information from linked tables.
[15 pts] Write a short report describing your design experience, any assumptions you make, any design choices you make, and some ideas for what else you could do with your database (if you had all the time and interest!)
Review the Rubric!!

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

Advances In Databases 11th British National Conference On Databases Bncod 11 Keele Uk July 7 9 1993 Proceedings Lncs 696

Authors: Michael F. Worboys ,Anna F. Grundy

1993rd Edition

3540569219, 978-3540569213

More Books

Students also viewed these Databases questions

Question

What are oxidation and reduction reactions? Explain with examples

Answered: 1 week ago

Question

Classify delivery styles by type.

Answered: 1 week ago