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, 12^th 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

Required(*) Message

User Account

All Pages