Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I have this SQL assignment and I need help :> This project requires you to implement a portion of the database that you have been

I have this SQL assignment and I need help :>

image text in transcribed

image text in transcribed

image text in transcribed

This project requires you to implement a portion of the database that you have been working on for the Great Lakes Fitness Center member tracking and billing system. It is to be done using SQL-Developer on the Oracle data server. You need to create a number of tables, and load them with sample data. Finally, you will run some queries against this data set. The tables represent a subset of the tables generated in the database design process. In addition, some columns have been dropped to make the exercise tractable. All tables are to be created in your assigned area in the appropriate tablespace. Table and column names cannot be changed. The column formats have not been specified. You need to assign each column an appropriate format (both type and length). The only constraints are that all dates and times must appear in a DATE format. Other than that, you should choose reasonable formats, particularly if you are doing computations with the data. Remember that these formats must be identical for foreign keys and any form of referential integrity. This project requires you to: Create all the tables specified (including primary keys [underlined] and foreign keys [dotted underlined]). Referential integrity requires that you create the referenced table first. Save each SQL CREATE statement as create01.txt, create02.txt, ... create 08.txt (no spaces and no tablenames). These must be pure text/ASCII files. Create these files before you run the command. Create the data to load these tables. You will have to create the data yourself, since providing you the data merely reduces this to a data entry exercise. Guidelines are provided for creating the data. You are encouraged to be creative in this task. You need to make sure that your data is realistic, and is consistent with the details in the case. Load the tables with the appropriate data. You can do this in a variety of ways, including using SQL INSERT statements, and direct entry into the datagrid in SQL-Developer. Make sure that referenced tables are loaded first. Also make sure that date column include a time component, when applicable. Print out the contents of all tables. Make sure that times are displayed. Create and save queries to retrieve the requisite data. Name these queries as query01.txt, query02.txt, ... query 10.txt (no spaces). When assembling the queries, you must use the full table names, i.e. userid.tablename and not just tablename. Without this, I will not be able to grade your project. As before, these must be pure text/ASCII files. Print out the results of running the queries. Grant SELECT authority on all tables you create to derek. This is important - I will not be able to grade your project without it. This project requires you to implement a portion of the database that you have been working on for the Great Lakes Fitness Center member tracking and billing system. It is to be done using SQL-Developer on the Oracle data server. You need to create a number of tables, and load them with sample data. Finally, you will run some queries against this data set. The tables represent a subset of the tables generated in the database design process. In addition, some columns have been dropped to make the exercise tractable. All tables are to be created in your assigned area in the appropriate tablespace. Table and column names cannot be changed. The column formats have not been specified. You need to assign each column an appropriate format (both type and length). The only constraints are that all dates and times must appear in a DATE format. Other than that, you should choose reasonable formats, particularly if you are doing computations with the data. Remember that these formats must be identical for foreign keys and any form of referential integrity. This project requires you to: Create all the tables specified (including primary keys [underlined] and foreign keys [dotted underlined]). Referential integrity requires that you create the referenced table first. Save each SQL CREATE statement as create01.txt, create02.txt, ... create 08.txt (no spaces and no tablenames). These must be pure text/ASCII files. Create these files before you run the command. Create the data to load these tables. You will have to create the data yourself, since providing you the data merely reduces this to a data entry exercise. Guidelines are provided for creating the data. You are encouraged to be creative in this task. You need to make sure that your data is realistic, and is consistent with the details in the case. Load the tables with the appropriate data. You can do this in a variety of ways, including using SQL INSERT statements, and direct entry into the datagrid in SQL-Developer. Make sure that referenced tables are loaded first. Also make sure that date column include a time component, when applicable. Print out the contents of all tables. Make sure that times are displayed. Create and save queries to retrieve the requisite data. Name these queries as query01.txt, query02.txt, ... query 10.txt (no spaces). When assembling the queries, you must use the full table names, i.e. userid.tablename and not just tablename. Without this, I will not be able to grade your project. As before, these must be pure text/ASCII files. Print out the results of running the queries. Grant SELECT authority on all tables you create to derek. This is important - I will not be able to grade your project without it

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

Spatial Database Systems Design Implementation And Project Management

Authors: Albert K.W. Yeung, G. Brent Hall

1st Edition

1402053932, 978-1402053931

Students also viewed these Databases questions

Question

3. Explain the forces that influence how people handle conflict

Answered: 1 week ago