database design and erd creation
You have been asked to design a relational database for a bookstore. The logical database design that you create this week will be used as the basis for the individual assignments throughout this course.
Complete for the following:
- Perform a logical design on the proposed database. Include the identification of all entities and attributes associated with the environment. The database should consist of a minimum of four tables.
- Create a detailed entity-relationship diagram (ERD) using the data specifications from the logical design. The ERD can be created within Microsoft® SQL Server® Management Studio using the Database Diagram Tools.
Capture and paste screenshots of your logical design, including the process you went through in creating the design, into PowerPoint® or Word for submission. This document should also include the process you went through to select the appropriate data types and primary keys.
Submit your document to the Assignment Files tab above.