Reference no: EM13854704
1. The table below contains sample data for parts and for suppliers who provide those parts. In discussing this data with users, we find that part ID, but not names, uniquely identify parts and that supplier names uniquely identify suppliers.
1-In what normal form is the table as it is currently presented? Why?
2-Convert the table into a relation PART_SUP. In what normal form is this relation and why?
3-For the PART_SUP relation, give specific examples of insertion, deletion, and modification anomalies, based on the data.
4-Create the set of relations needed to represent the data in 3NF.
|
PartID
|
PartName
|
SupName
|
City
|
UnitCost
|
|
1234
|
Logic Chip
|
Intel
|
Cupertino
|
10.00
|
|
|
|
AMD
|
Phoenix
|
8.00
|
|
5678
|
Memory Chip
|
Intel
|
Cupertino
|
3.00
|
|
|
|
ChipsRUs
|
Tucson
|
2.00
|
|
|
|
AMD
|
Phoenix
|
5.00
|
2. For the following, (1) determine what normal form it is currently in, (2) explain why it's in that normal form (and not others), and (3) convert it into 3NF if it's not already there.
CLASS(CourseID, InstID, CourseName, ClassTime, InstName)
FD: CourseID -->CourseName
FD: InstID -->InstName
JOBS(EmployeeID, DeptNum, JobID, JobTitle, EmpName)
FD: JobID -->JobTitle
3. Transform the following E-R Diagram into a set of relations in 3NF. Be sure to list all foreign key constraints.
|
About the relative factor abundance of the two countries
: Suppose that each unit of product A requires 4 workers and 1 unit of capital to produce, whereas each unit of product B requires 5 units of capital and 2 workers and that it is the case irrespective of prices (no factor substitution). What does this ..
|
|
Definitions of factor abundance and factor intensity
: Suppose Canada has 100 workers and 160 units of capital whereas Mexico has 100 workers and 70 units of capital. Apply the definitions of factor abundance and factor intensity to sort countries and products. What would you expect the pattern of trade ..
|
|
Case study: government jobs
: What hobby or part-time job do you have that can lead to con-sumer benefit. How can you develop that into something you can put on your resume. What connection can you make between that and the major you are good at
|
|
The constant elasticity of substitution function
: The Constant Elasticity of Substitution function. Determine the returns to scale of this production function. Find σ, the elasticity of substitution. Express K/L as a function of w/r. How does the relationship between K/L and w/r change when ρ chang..
|
|
Sample data for parts and for suppliers
: 1. The table below contains sample data for parts and for suppliers who provide those parts. In discussing this data with users, we find that part ID, but not names, uniquely identify parts and that supplier names uniquely identify suppliers.
|
|
What specifically should be done to ensure that kamp
: What specifically should be done to ensure that KAMP is successful
|
|
Which of the given alternative would you choose
: Assuming you could earn 10%annually, which alternative would you choose? If you earn 11% annually would still choose the same alternative?
|
|
According to the benefit principle of taxation
: Abe, Betty and Charlie are the only three students in my graduate Public Finance class and I am trying to determine how many office hours to hold per week for this class. according to the benefit principle of taxation. What would I charge each studen..
|
|
Current account balance and capital account balance
: Suppose a country has net exports of 40, transfer payments of 20, net investment income of -15, and a balance of payments surplus of 10. Find the country's current account balance and capital account balance.
|