Create a database named PVFC

Assignment Help Database Management System
Reference no: EM131697152

Database Management Assignment - SQL Queries for Pine Valley Furniture Corporation

Part 1 - Define and Populate the Database

Use Oracle Database Configuration Assistant to create a database named PVFC-{Yourlastname} Make sure that it is NOT a container database.  Also provide passwords for users SYS and SYSDBA.

Connect as user sys with role as sysdba. In DBA view create a user, grant user appropriate privileges to connect and manipulate database objects.  Connect to the database as this user.

Use the attached DDL script CreateBigPV.sql to create tables and define constrains.   Please check the script to make use that you understand different data types, primary key, and foreign key constraints. 

Create the relational model for the database.  Compare it with Figure 2.22 in the textbook.  The following table gives the correspondence between the figure and tables.  You may notice in translating E-R diagrams to tables that some of the entities have been renamed - e.g. HAS SKILL in figure has been implemented as EmpoyeeSkill_T. 

Now use scripts Load1BigPV.sql and Load2BigPV.sql in that order to load data into the database.  (The order is important because of the referential integrity constraints; we have to load data into tables on 1 side of a relationship before we can load matching records on the many side of the relationship.)

Part 2 - SQL Queries for Data Retrieval

Create a New Project

Switch to data perspective and create a new project based on the connection.  Examine data in each table using SELECT command.

Practice SQL

Use Oracle SQL Developer to practice building SQL queries for exercises 6-57 through 6-85 on pages 284-286.  Some the queries will be very simple (e.g. 6-58, 6-59), some will require running aggregates (e.g. 6-69), some will require you to find additional date function in Oracle (e.g., 6-77).  More you practice, better you will become at developing SQL statements, 

Use definition on page 309 to create view TSALE.  Use this view to answer Query 1 on page 309.  Change SELECT query on page 310 to create view TOPTERRITORY query and then use this view to answer Query 2 on page 310.

Textbook - Modern Database Management, 12th edition by Jeffrey A. Hoffer, V. Ramesh and Heikki Topi.

Reference no: EM131697152

Questions Cloud

What is the cost of common equity : The stock is expected to pay a dividend of $3.00 per share at the end of the year and the dividend is expected to grow at a constant rate of 5.0% per year.
What is the company cost of preferred stock : Stephens Pharmaceuticals can issue perpetual preferred stock at a price of $50 per share with an annual dividend of $4.50 per share.
Determine the quantity of grout needed for the wall : Determine the quantity of grout needed for the wall in Problem if 16 cubic feet of grout is required per 100 square feet of block.
Discuss the pros and cons of these methods : Discuss the pros and cons of these methods, and provide some examples of each method and if it has or has not been successful.
Create a database named PVFC : ISGB 7973, Database Management Assignment. Use Oracle Database Configuration Assistant to create a database named PVFC-{Yourlastname}
What is double d after tax cost of debt : DoubleD believes it could issue new bonds at par that would provide a similar yield to maturity. If its marginal tax rate is 35%, what is Double D's after tax?
Find number of standard blocks that can be deducted : The wall is constructed of 7 5/8-inch-high by 7 5/8-inch-wide by 15 5/8-inch-long blocks with a 3/8-inch mortar joint.
What is the relevance of the investment grade : What is the benefits to a debt issuer of a credit ratings? What is the relevance of the investment grade?
How much will she have at the end of 20 years : Brittany Willis is looking to invest for retirement, which she hopes will be in 20 years. She is looking to invest $22,500 today in U.S.

Reviews

len1697152

10/30/2017 2:21:09 AM

In this assignment you will use the example of Pine Valley Furniture Corporation described in the throughout the textbook starting chapter 2 to further practice your SQL skills. Although you will submit the solution to only a few exercises from chapters 6 and 7. I would urge you to work through as many exercises as you can so that you become expert at SQL. Next week practice building queries for exercises 7-42 through 7-76. Work to Submit - Submit queries and resulting tables for problems 6-63, 6-67, 6-70, 6-72, 6-78, 7-46, 7-61, 7-65, 7-66, and 7-55.

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd