Project #20611 - Regional Database

Questions:

1. The Relational Model: Advance Topics

A. In the following exercises use the data in the Premiere Products database shown in Figure 2-1 in Chapter 2.

  1. Find the order number and order date for every order that contains part number XX34
  2. Find the order number and order date from every order that includes a part located in warehouse number 12.
  3. SAME AS #2 but use nested queries.
  4. Use INTERSECT. List customer number, customer name for every customer who is either represented by sales rep number 345 or who currently has orders on file (CustomerNUM in ORDERS).
  5. Use MINUS. List customer number, customer name for every customer who is either represented by sales rep number 345 or who does not have orders currently on file.

2. Normalization

A. “Obtain a common document such as a sales slip, customer invoice from an auto repair shop, credit card statement, etc. anything you have will work, make sure personal information is not given or visible. Build your database to include the below information.  ***see note below assignment requirements.

  1. Use the normalization steps described in this chapter to convert this user view to a set of relations in third normal form.
  2. Draw a relational schema.
  3. List several integrity rules that you would recommend to ensure the quality of the data in this application”  (Hoffer, Prescott, & Topi, 2009, p. 250).

****Please submit this Question separately and post what Database format was used: Access, mySQL, etc.

Essay Questions. 

3. Design Method:

 “Denormalization can be a controversial topic among database designers. Some believe that any database should be fully normalized. Others look for ways to denormalize to improve processing performance. What is your opinion? Why?” (Hoffer, Prescott, & Topi, 2009, p. 302).

4. DBMS Functions and Database Administration

“Visit some of the Web sites for open-source databases, such as www.postgresql.org and www.mysql.com.

 What do you see as major differences in administration between open-source databases, such as MySQL, and commercial database products, such as Oracle? How might these differences come into play when choosing a database platform? Summarize the DBA functions of MySQL versus PostgresSQL“(Hoffer, Prescott, & Topi, 2009, p. 612).

Subject Business
Due By (Pacific Time) 01/11/2014 02:00 pm
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy