User Account

All Pages

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

  Add a validation rule for date of birth

Make an Update Query that will add the phrase "Free Champagne for this Preferred Guest" to the Comments field, but only if the guest stays for 8 days or more.

  What are some faster ways to accomplish data collection

Data collection takes a lot of time. Therefore, it is not worth the time and trouble. What do you think? What are some faster ways to accomplish data collection

  Create a sub directory called your name under the class

Create a sub directory called your name under the class directory.

  Create an enhanced erd to meet requirements

Create an enhanced ERD to meet requirements. Ensure that entities are properly defined and appropriate attributes are listed for each entity. Also, ensure that all entities are properly related.

  Explain techniques for distributed data placement

Create a diagram using Visio, Microsoft Paint, or other graphical creation utility of your choosing to illustrate the diagrams supporting your conclusion. Note: The graphically depicted solution is not included in the required page length.

  Formulate the problem of determining the optimal locations

Consider the University of the Far West described in Example. Suppose that the university administration has decided that two audiovisual centers are needed.

  How to set up and test your database

How to set up and test your database? An ERD diagram of your database design showing primary keys, foreign keys and other constraints.

  Write down sql dml statements which address the given

write sql dml statements that address the following requirements 1 update the employees table and give all employees

  What is the sum total amount paid with check

What is the sum total amount paid with Check? List the first and Last names of the vets who work at a hospital that starts with "Wo".

  Draw an functional decomposition diagram

Draw an functional decomposition diagram that shows the main operations described in the fact statement - prepare a context diagram and diagram 0 DFD for the new system.

  Create the tables and relationships from the database

Refer to the database design crested in Lab 2: Modifying a Database Design to complete this Lab. Create the tables and relationships from the database design discussed in Lab 2. Add at least five (5) records into each table (Note: You must determine ..

  Explain process for coding and categorizing qualitative data

Explain your process for coding and categorizing the qualitative data. What patterns and/or themes did you discover?

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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