Question

you will write your solutions to problems A - G. You will turn in this assignment...

you will write your solutions to problems A - G.

You will turn in this assignment by uploading a PDF file that contains your answers.

Using these relations:

CUSTOMER(CustomerID, LastName, FirstName, EmailAddress, EncryptedPassword, Address, City, State, ZIP, Phone, ReferredBy)

SALE(SaleID, CustomerID, InvoiceDate, PreTaxTotal, Tax, Total)

SALE_ITEM(SaleID, SaleItemID, PurchaseID, SalePrice)

PURCHASE(PurchaseID, PurchaseItem, PurchasePrice, PurchaseDate, VendorID)

VENDOR(VendorID, Vendor, Phone)

A.

1. List all functional dependencies.

2. List any multivalued dependencies.

3. List all candidate keys.

4. List all primary keys.

5. List all foreign keys.

6. State any assumptions you make as you list these components.

B. List questions you would ask the owners of the Queen Anne Curiosity Shop to verify your assumptions.

C. If there were any multivalued dependencies, create the tables needed to eliminate these dependencies.

D. Do these data have the multivlue, multicolumn problem? If so, how would you deal with it?

E. Do these data have the inconsistent data problem? If so, how would you deal with it?

F. Do these data have a null (missing) value problem? If so, how would you deal with it?

G.Do these data have the general--purpose remarks value problem? If so, how would you deal with it?

0 0
Add a comment Improve this question Transcribed image text
Answer #1

1)

Functional dependencies

CUSTOMER

CustomerID -> { LastName, FirstName, EmailAddress, Address, ZIP, Phone, ReferredBy }

EmailAddress -> { EncryptedPassword }

Zip -> { City, State }

SALE

SaleID -> { CustomerID, InvoiceDate, PreTaxTotal, Tax, Total }

SALE_ITEM

{ SaleID ,SaleItemID } -> { PurchaseID, SalePrice }

PURCHASE

{ PurchaseID , PurchaseItem } -> { PurchasePrice, PurchaseDate, VendorID }

VENDOR

VendorID -> { Vendor, Phone }

2)

Multivalued dependency

Phone in CUSTOMER table

Phone in VENDOR table

3)

Candidate keys

CUSTOMER

CK = { CustomerID } , { EmailAddress } , {Zip}

SALE

CK = { SaleID }

SALE_ITEM

CK = { SaleID ,SaleItemID }

PURCHASE

CK = { PurchaseID , PurchaseItem }

VENDOR

CK = {VendorID }

4)

Primary keys

CUSTOMER

PK = { CustomerID }  

SALE

PK = { SaleID }

SALE_ITEM

PK = { SaleID ,SaleItemID }

PURCHASE

PK = { PurchaseID , PurchaseItem }

VENDOR

PK = {VendorID }

5)

Foreign keys

SALE

FK = CustomerID,

SALE_ITEM

FK = SaleID , PurchaseID

PURCHASE

FK = VendorID

*************END**************PLS GIVE ME GOOD RATING****************************

Add a comment
Know the answer?
Add Answer to:
you will write your solutions to problems A - G. You will turn in this assignment...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • THE QUEEN ANNE CURIOSITY SHOP PROJECT QUESTIONS Figure 2-36 shows typical sales data for the Queen...

    THE QUEEN ANNE CURIOSITY SHOP PROJECT QUESTIONS Figure 2-36 shows typical sales data for the Queen Anne Curiosity Shop, and Figure 2.37 shows typical purchase data. A. Using these data, state assumptions about functional dependencies among the columns of data. Justify your assumptions on the basis of these sample data and also on the basis of what you know about retail sales. FIGURE 2-36 Sample Sales Data for the Queen Anne Curiosity Shop LastName FirstName Phone InvoiceDate Shire Robert 206-524-2433...

  • C++ In this assignment, you will write a class that implements a contact book entry. For...

    C++ In this assignment, you will write a class that implements a contact book entry. For example, my iPhone (and pretty much any smartphone) has a contacts list app that allows you to store information about your friends, colleagues, and businesses. In later assignments, you will have to implement this type of app (as a command line program, of course.) For now, you will just have to implement the building blocks for this app, namely, the Contact class. Your Contact...

  • I need help making this in C++ Asap! If you feel information is missing, or provided...

    I need help making this in C++ Asap! If you feel information is missing, or provided information is incorrect, make assumptions but clearly state your assumptions. You should NEVER use global variables. Other than the main() function, there should be no global functions in your code. Other than the test() function not other function needs to be a static function in this problem. Let us say you find a consulting opportunity for a regional real-estate company that wants you to...

  • #Using this assignment prompt below and your knowledge from your reading, come up with three solutions...

    #Using this assignment prompt below and your knowledge from your reading, come up with three solutions on how to handle the problem. Write 250 words paper# You take any and every chance you can to get out of the office and away from your phone and e-mail. You are the sales manager and your team is outstanding at getting new clients! Recently, your new boss Ethan was hired. He is in charge of scheduling and he's the production manager. As...

  • Problem 2 Assume that you want to design a hashtable to store data of employees in a company. The ID of each worker...

    Problem 2 Assume that you want to design a hashtable to store data of employees in a company. The ID of each worker is his primary phone number in the form of 10 digit number (Area code-three digits carrier-4 digits id), Knowing the following constraints (information). a) Employees can differ only on the three low significant digits, the fifth and the sixth digits; they all have the same digits for the fourth, seventh, eighth, ninth and tenth digit. b) No...

  • ANSWER THE FOLLOWING QUESTIONS: Problem 2 Assume that you want to design a hashtable to store data of employees in a co...

    ANSWER THE FOLLOWING QUESTIONS: Problem 2 Assume that you want to design a hashtable to store data of employees in a company. The ID of each worker is his primary phone mumber in the form of 10 digit number (Area code-three digits carrier-4 digits id). Knowing the following constraints (information). a) Employees can differ only on the three low significant digits, the fifth and the sixth digits; they all have the same digits for the fourth, seventh, eighth, ninth and...

  • Your company provides you with a car. You are told only to drive in Dade and...

    Your company provides you with a car. You are told only to drive in Dade and Broward and only to use the car for business purposes. One weekend your family is going to the Keys. You get in your personal car and it won’t start so you take the company car to the Keys, which is in Monroe, for the weekend. When you return to work on Monday your boss calls you in his office and asks you why you...

  • a. You have 5 problems in this assignment. b. G++ compiler will be used to compile...

    a. You have 5 problems in this assignment. b. G++ compiler will be used to compile your source codes. c. Your program will be tested on Ubuntu 16.04. d. You are not allowed to use global variables in your implementation. e. Your program will get two arguments, input and output file names, from the command line: >> Your_Executable INPUT_FILE_NAME OUTPUT_FILE_NAME 1. Given a number ? , we initially have ?+1 different sets which are {0}, {1}, {2}, ... , {?}....

  • == Programming Assignment == For this assignment you will write a program that reads in the...

    == Programming Assignment == For this assignment you will write a program that reads in the family data for the Martian colonies and stores that data in an accessible database. This database allows for a user to look up a family and its immediate friends. The program should store the data in a hashtable to ensure quick access time. The objective of this assignment is to learn how to implement and use a hashtable. Since this is the objective, you...

  • Assignment Overview This writing assignment requires you to have a general idea of a researchable topic...

    Assignment Overview This writing assignment requires you to have a general idea of a researchable topic related to the field of business. You will create a knowledge list, an expansive compilation of questions, an inquiry question, and a research proposal that you will likely address later through your final research paper. Deliverables 2- page paper (12 point font) written in a word processing program (such as MS Word). Activity Details Perform the following tasks: Step 1: Create a knowledge list...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT