Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I am currently using WAMPSERVER to access MySQL. I will send an attachment of the EER diagram that I have created for this. Using MySQL,
I am currently using WAMPSERVER to access MySQL. I will send an attachment of the EER diagram that I have created for this.
Using MySQL, and based upon the final EER diagram that you created for the second project deliverable. Develop your database and populate your tables with data. The data may be real or fictitious, or some combination of the two - but the values should be realistic for your chosen application. Each table should have enough data to make the query results interesting (at least 5-10 tuples). Make sure to set reasonable attribute domain constraints as your choices can make a large impact in the efficiency of the overall system. Set up your database by creating the relations and defining the appropriate constraints (domain, entity, and referential). Please then develop at least 3 SELECT queries (or at least 5 SELECT queries if you are working in a group) that represent answers to likely business questions to be faced by the users of your database system. For each of these queries, please also provide a 1-2 sentence, solid business justification for why that query is relevant and interesting to the owners of the system, and how it will actually help them. Your queries should not be overtly obvious or simple (i.e., you should not just list everything from your Customer table!). Please realize that the more complex the queries are, the more interesting (and useful) they will probably be. At least 2 of your queries (3 for a group submission) need to use subqueries and/or involve table joins. You do not yet need to create any parameterized queries. Each of your queries must be set up with appropriate aliases for the column names and appropriate formatting for the different data tyes $XXXX for currency, etc.), so that they will be professionally formatted if used to generate output reports. Please save all of your queries, together with their 1-2 sentence business justifications, in a PDF document. This document should be named DB3-groupNNjust.pdf, where NN is your 2-digit group number (i.e., DB3-group01-just.pdf, etc.). Please then also export a copy of your database as a text file in SQL format (see below). This text file should be given a .sql extension (the standard identifier for a text file containing SQL statements) instead of .pdf: DB3-groupNNdatabase.sql. Please be sure that your final .sql file contains both the CREATE DATABASE and USE statements, as in the class.sql database. Finally, please create a separate text file that contains only. your SQL statements, each one starting on a new line and ending with a semicolon. This file will be used to run your SQL statements on your database and should be named: DB3-groupNN-queries.sql
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started