Access Application Development...

Access Application Development This database application can be used by the employees and managers of the CD warehouse, the customers, the suppliers, the database administrator, etc. ln the following figure we present a tentative layout of the system. ln the welcome screen, the user can choose one of the three options presented. we give details about the forms or set of forms to be included in each option; however, you are encouraged to add other forms you find relevant. we suggest that the queries, forms, and reports already created in the Access Application Development section be included in here....

Read more »

Database Design...

Database Design We present the main entity types of this database. For each entity type, we provide some of the corresponding attributes. Use this information in order to: (a) Build an Enhanced E-R diagram; (b) Transform the Enhanced E-R diagram to a relational database. identify the primary key(s) and the foreign key(s) for each relation. Draw the relational integrality constraints; (c) For each of the. relations created, indicate its normal form. lf the relation is not in the 3NF, decompose it into 3NF relations. 1. Album. The main attributes are identification number, name, songs, members, release date, warehouse location, quantity available, category, etc. 2. Customer. The main attributes are identification...

Read more »