Choose one of the existing databases from the databaseanswers site. The ER diagram should have a minimum of 4 entities.
The database has to be buit in SQL with following specifications:
- Form the database, with each table having 5 rows, and insert values in rows as specified by the fields.
- Form the relationship diagram
- Write five queries which are meaningful to your database. This should include a join, aggregates and group by.
Please use MS Access.
Question
Solution Preview
This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.
By purchasing this solution you'll be able to access the following files:
Solution.docx and Solution.accdb.
Return to homework library