Reference no: EM13879588
1. Using the following FD list for a simplified expense report database, identify insertion, update, and deletion anomalies if all columns are in one table (big expense report table). There are two candidate keys for the big expense report table: ExpItemNo (expense item number) and the com bination of CatNo (category number) and ERNo (expense report number). ExpItemNo is the primary key of the table.
• ERNo ->UserNo, ERSubmitDate, ERStatusDate
• ExpItemNo ->ExpItemDesc, ExpItemDate, ExpItemAmt, CatNo, ERNo
• UserNo ->UserFirstName, UserLastName, UserPhone, UserEmail
• CatNo ->CatName, CatLimit
• ERNo, CatNo ->ExpItemNo
• UserEmail -» UserNo
• CatName ->CatNo
2. Using the FD list in problem 1, identify the FDs that violate 2NF. Using knowledge of the FDs that violate 2NF, design a collection of tables that satisfies 2NF but not 3NF.
3. Using the FD list in problem 1, identify the FDs that violate 3NF. Using knowledge of the FDs that violate 2NF, design a collection of tables that satisfies 3NF.
4. Apply the simple synthesis procedure to produce BCNF tables using the FD list given in prob lem 13. Show the results of each step in your analysis.
|
Find optimal solution using the simplex method
: Find the optimal solution to this problem using the simplex method. Write out each simplex tableau, and show all your work in arriving at each tableau. Clearly label each tableau.
|
|
Article- improvement and recovery from eating disorders
: Article- Improvement and Recovery from Eating Disorders: A Patient Perspective. Describe the article and the research article driving the article
|
|
Most frequently use which two types of investment criteria
: In actual practice, managers most frequently use which two types of investment criteria?
|
|
What is the significance of currency devaluations to home
: What is the significance of currency devaluations to the home country?
|
|
Design a collection of tables that satisfies 2nf but not 3nf
: Using the FD list in problem 1, identify the FDs that violate 2NF. Using knowledge of the FDs that violate 2NF, design a collection of tables that satisfies 2NF but not 3NF.
|
|
What is your recommendation on this project
: A project has a discount rate of 14 percent, an initial cost of $99,200, an inflow of $56,400 in year 1 and an inflow of $75,900 in year 2. Your boss requires that every project return a minimum of $1.06 for every $1 invested. Based on this informati..
|
|
Uniquely designed to the customers specifications
: Auto Art sells original works of art on a prepaid basis as each piece is uniquely designed to the customer's specifications. For one project, the cash flows are $9,500 and -$10,300 for years 0 and 1, respectively. Based on the internal rate of return..
|
|
Reject these projects based on IRR analysis
: You are considering two mutually exclusive projects. Project A has cash flows of -$125,000, $51,400, $52,900, and $63,300 for years 0 to 3, respectively. Should you accept or reject these projects based on IRR analysis?
|
|
Draw a supply and demand graph illustrating the effect
: Draw a supply and demand graph illustrating the effect of a minimum wage
|