Assignment - Create a Computer Store database system with only 5 entities, staff, customer, product, pricing and sale, design the database, and implement it using RDMS (Microsoft SQL Server, or MySQL) and use Visual Basic for the interface of the store. Populate the database, write statements to manipulate the database, write queries to retrieve information, explore other aspects such as constraints and triggers.
- An E/R diagram for the Computer store database. Underline key attributes for entity sets, specify relationships and their multiplicities.
- Relational model, BCNF verification. For each table, show the attribute dependencies, and explain why it is in 1NF, 2NF, 3NF and BCNF;
- A complete list of uses cases that include actor and step-by-step descriptions.
- Use case realization (include the SQL statements that implement every use case). Once again, be sure to have: for each entity, at least one insert, one delete, one update, and one aggregate query; and for each set of entities that have a direct relationship, one joint query.
Make a demo to show all the major functionalities of the computer store database product. For the demo submission, you need to populate all the tables, then perform and record the following queries and their outputs:
- For each table, show all data;
- For each table, perform a query using at least one of the aggregate functions;
- For each relationship, perform a joint query on the tables that are DIRECTLY related through that relationship.