Question

Develop and ERD and a data dictionary for a database that tracks inventory for the Potlatch Bow and Arrow Factory. Entities to include: Orders Purchases Products Include a data dictionary.?

Answer 1

Create Database in Access for the Bovil Bow and Arrow Factory to keep track of their customers. The database should track the following:

-Customer identification and address information

-Sales Information

-Any complaints they may have.

Deliverables

-ERD

-Data Dictionary

-Database built in Access

-Screen shot of every table

-Screen shot of the Relationship page

-Put in test data (use movie stars or some other bogus name)

-Develop a Query in Access

-Screen capture of the database, both with data and in SQL view.