Database management
Sahil08Part 2: -
Project Implementation –
Report 2 Contents:
1) Project goals.
2) Database description: A general description of the database, what data is stored in the database.
How the database will benefit the users.
3) Data model & design:
Completed ER/EER diagram, 5 tables minimum (8 tables in case the group has 2
members)
-MUST use https://www.draw.io to draw the ER diagram, and then take a
snapshot.
-Include a snapshot of the diagram in the report.
- Business rules.
-Data dictionary: For each one of the tables, list columns, data types, column restrictions,
column descriptions.
4) Implementation:
-Use MySQL Server and MySQL Workbench to create the database/tables.
-Include a snapshot of the SQL code in your report
-Populate the each table with a minimum of 20 rows of sample data. Make sure the
entered data is descriptive (not just random numbers and letters.
- Include a snapshot of the SQL code in your report.
- Use MySQL Server and MySQL Workbench to write/run the SQL queries below. For
each query, provide the following in Report 2:
- Snapshot of the code and the output in the report.
- In about 2 lines, explain what the query returns.
Queries:
- 1 trivial query. Simple select with ordering.
- 2 medium difficulty queries. Queries that use composite condition for selection,
computations, aggregate function and grouping.
- 1 query that uses subquery.
- 2 queries that uses join (1 inner join, 1 left or right outer join).
- 1 view (query must use join – hint: you can use one of the queries from the
previous question).
- 1 query that uses union.
- 1 custom stored function.
-1 custom stored procedure.
Part 3: Presentation
1. Create a PowerPoint presentation of your project, the presentation should contain the
following:
• Project description
• Project goals.
• ER diagram (same ER in Report 2).
• Ten snapshots of the queries with their output and a little bit of description on what
does each query do.
• Note: Even if you are working in a group of two, you only need to include 10 queries
in the presentation.
• Project difficulties.
- 2 years ago
- 15
Purchase the answer to view it
- Mysql.zip
- Databasemanagementpart2n3rev.docx
- Economic Development Institutions
- Fire Protection Technology
- Police Legitimacy and Procedural Justice
- case2
- Jornal of violation, cross-culture class
- Written Assignment - Research Your Personal Job (Police Officer)
- UNIVERSITY OF SOUTH FLORIDA Department of Economics Summer 2013 Michael Loewy ECO 3622 001
- QNT 351work sheet
- Week 2 - Discussion 2 - Strategic HR Mgmt- Initial post due by Wed 6/8
- Is this treatment accurate? Why or why not?