Reference no: EM13926231
Phillip Morgan, the owner of Morgan Importing, makes periodic buying trips to various countries. During the trips, he keeps notes about the items he purchases and basic data about their shipments. He hired a college student as an intern, and she transformed his notes into the spreadsheets in Figure.
This is just sample data. Phillip has purchased hundreds of items over the years, and they have been shipped in dozens of different shipments. Phillip wants to enter the information age, thus he has decided to develop a database of his inventory. He wants to keep track of the items he has purchased, their shipments, and eventually customers and sales.
To get started, he has asked you to create a database for the data in (attached file). To complete this assignment, you must complete following instructions and provide detailed answers for each item:
A. Follow the "Assessing Table Structure" procedure shown. List multivalued dependencies, functional dependencies, candidate keys, primary keys, and foreign keys. State your assumptions.
B. List questions you would ask Phillip to verify your assumptions.
C. Create tables as necessary to eliminate multivalued dependencies, if any.
D. The relationship between shipment and item data could be inferred by matching values in the From cells to values in the City cells. Describe two problems with that strategy.
E. Describe a change to this spreadsheet that does express the shipment/item relationship.
F. Assume that Phillip wishes to create an updateable database from this data. Design tables you think are appropriate. State all referential integrity constraints.
G. Assume that Phillip wishes to create a read-only database from this data. Design tables you think are appropriate. State all referential integrity constraints.
H. Do these data have the multivalue, multicolumn problem? If so, how will you deal with it?
I. Do these data have the inconsistent data problem? If so, how will you deal with it?
J. Do these data have a null value data problem? If so, how will you deal with it?
K. Do these data have the general-purpose remarks problem? If so, how will you deal with it?
|
Analyzing the integrated business communication
: Write a three to four (3-4) page paper addressing the following: Identify the Web site, the sender, and perceived receiver. Analyze the integrated business communication.
|
|
What strategic insight will these indicators provide
: How would you recommend positioning the company at the present time to monopolize on current conditions? Would you change that positioning in the near future?
|
|
Quality service in hospitality organizations
: Take a position on this statement: Hospitality organizations are obligated to provide quality service. Provide a rationale with your response. Ponder this statement: "It begins - and ends - with the guest." In your own words, describe what this st..
|
|
Societies set benchmarks to guide members via communication
: Societies set benchmarks to guide members through communications with one another. Also, however, it is not frequently evident to the stripped eye; organizations have comparative measures administering their activities and capacity to keep workin..
|
|
Eliminate multivalued dependencies
: Create tables as necessary to eliminate multivalued dependencies, if any.
|
|
How to develop the therapeutic alliance
: Ethical Principles of Psychologists and Code of Conduct - Consider the behavior of the addictions professional in the media in the context of the codes of conduct established by the APA and the NAADAC.
|
|
How you will evaluate and hold employees accountable
: Assume that you are the hiring officer in your agency. Discuss a minimum of three things you will look for when choosing your staff. Determine and discuss how you will evaluate and hold employees accountable
|
|
Gasb rules for the financial reporting entity
: Under GASB rules for the financial reporting entity a. component units are included if the primary government is financially accountable for their operations B. counties are component units of the state government
|
|
Record the bad debts expense
: Management estimates that 1% is the sales percentage to use. What adjusting entry will Hahn Company make to record the bad debts expense?
|