Reference no: EM131116975
A consulting company named Database Experts has also designed a logical schema for CPC. CPC found that their design is different from yours. There is the following table in their logical schema.
Donation (Donator#, Program#, Date, Amount, Title, Theme, Deadline)
The requirements of CPC also indicate that there are the following Functional Dependencies:
Donator#, Program# -> Date, Amount
Program# -> Title, Theme, Deadline
Theme -> Deadline
Although the designers at Database Experts claim that their design is superior in all aspects, CPC gives you a fair chance to justify your position. Now it's your time to do the following.
1). Find the primary key for the table DONATION (You have to show the process)
2). Determine which normal form the DONATION table is in. Explain why.
3). Decompose their table into 3NF tables. Specify primary keys and foreign keys of your tables. (You need to show the process)
|
Performance has been dropping steadily over last five months
: You have recently been promoted to take over a poor performing team of ten. The team’s performance has been dropping steadily over the last five months. Among your many new responsibilities, you have been specifically asked to suggest specific ideas ..
|
|
Chain of service facilities
: A chain of service facilities (like automobile repair shops) has locations in three cities: A, B, C. Each facility sells two products: 1, and 2. These figures give the maximum demand at each location. It is perfectly possible for the firm to sell les..
|
|
Preparing the comparative financial statements
: Agassi Corporation is preparing the comparative financial statements to be included in the annual report to stockholders. Agassi employs a fiscal year ending May 31.
|
|
Lagreca company is involved in four separate industries
: (Segmented Reporting) LaGreca Company is involved in four separate industries. The following information is available for each of the four industries. Determine which of the operating segments are reportable based on the:
|
|
Question regarding the functional dependencies
: Donation (Donator#, Program#, Date, Amount, Title, Theme, Deadline) The requirements of CPC also indicate that there are the following Functional Dependencies:
|
|
An unqualified opinion on financial statements
: An auditor issued an unqualified opinion on financial statements that failed to disclose that a significant portion of the accounts receivable was uncollectible.
|
|
Birm plans to acquire a large firm in portugal that is risk
: Birm plans a licensing deal in which it will sell technology to a firm in Germany for $3 million; the payment is invoiced in dollars, and this projectb has the same risk level as its existing businesses. Birm plans to acquire a large firm in Portugal..
|
|
Process inventory account of phelan corporation
: The Work in Process Inventory account of Phelan Corporation increased $22,000 during November 2013. Costs incurred during November included $24,000 for direct material, $126,000 for direct labor, and $42,000 for overhead.
|
|
The endangered species act
: The Endangered Species Act (ESA) charges the National Marine Fisheries Service (a federal agency) with the duty to “ensure” that any proposed action by the Council does not “jeopardize” any threatened or endangered species. The Steller sea lion is on..
|