Answered step by step
Verified Expert Solution
Link Copied!

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,

image text in transcribed

I am currently using WAMPSERVER to access MySQL. I will send an attachment of the EER diagram that I have created for this.

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Understanding Oracle APEX 5 Application Development

Authors: Edward Sciore

2nd Edition

1484209893, 9781484209899