LEARN MORE...

Access Millions of academic & study documents

3 Here’s a table that’s not in First Normal FormThe tableAuto

Content type
User Generated
Showing Page:
1/3
3. Here’s a table that’s not in First Normal Form:
The table:
Automobile
class
modelName
compact
Focus, Fusion, Fit
midsize
Edge, Equinox, Flex
crossover
Escape, CRV, Pilot
suv
Expedition, Excursion, Escalade
The schema:
Automobile ( class, modelName )
(a) Normalize the tables by writing two schemas for new
tables.
(Remember the Multi-Valued Attribute pattern?)
Don’t show the whole tables, just jot down the schemas;
there will be two of them:
4. Write a sentence-fragment answer for each question
(except e) about this table:
The table:
IngredientOrder
ingredient
vendor
quantity
vendorPhone
01
Sysco
2
555-1212
01
FoodServ
4

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/3
777-8888
02
Sysco
3
555-1212
02
FoodServ
6
777-8888
03
Schwann
3
111-0000
04
Sysco
2
555-1212
04
FoodServ
4
777-8888
The schema:
IngredientOrder ( ingredient, vendor, quantity,
vendorPhone )
(a) There’s a repeated pairing of values that causes a fact
to be restated more than once. (This is a data
redundancy). What fact is being repeated?
(is FoodServ the only redundancy?)
(b) What\'s the key of the table?
(c) What\'s the determinant of vendorPhone?
(d) What normal form is in question for this table?
(e) Write the two schamas for the normalized tables. (Don’t
show the whole tables, just jot down the schemas; there
will be two of them).
class
modelName

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/3

Sign up to view the full document!

lock_open Sign Up
Unformatted Attachment Preview
3. Here’s a table that’s not in First Normal Form: The table: Automobile class modelName compact Focus, Fusion, Fit midsize Edge, Equinox, Flex crossover Escape, CRV, Pilot suv Expedition, Excursion, Escalade The schema: Automobile ( class, modelName ) (a) Normalize the tables by writing two schemas for new tables. (Remember the Multi-Valued Attribute pattern?) Don’t show the whole tables, just jot down the schemas; there will be two of them: 4. Write a sentence-fragment answer for each question (except e) about this table: The table: IngredientOrder ingredient vendor quantity vendorPhone 01 Sysco 2 555-1212 01 FoodServ 4 777-8888 02 Sysco 3 555-1212 02 FoodServ 6 777-8888 03 Schwann 3 111-0000 04 Sysco 2 555-1212 04 FoodServ 4 777-8888 The schema: IngredientOrder ( ingredient, vendor, quantity, vendorPhone ) (a) There’s a repeated pairing of values that causes a fact to be res ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Studypool
4.7
Indeed
4.5
Sitejabber
4.4

Similar Documents

ENGL 120 Cuyamaca College Rhetorical Analysis of Between the World and Me Essay
4 Pages: Typed, MLA FormatPrompt: Choosing a handful of specific passages in Between the World and Me, make an argument ab...
Psychology Question
Respond to the following essay questions about Lacey Schwartz and her family from the documentary film Little White Lie.&n...
American Public University Stressor Related Disorders Question
Students will select one psychological disorder described in your readings from the course textbook, Psychopathology: Foun...
CAT 125 University of California San Diego Week 5 Personal Brand Discussion
We made it to Week 5! For this week's discussion board you are going to do an online self-audit. This assignment is to hel...
The decision was made to use a process costing system, assignment help
The decision was made to use a process costing system. The first month of operation went fairly smoothly, and the CFO is r...
Grossmont Community College Introduction Presentation
Collage Presentation Grade Sheet (25 Possible Points) I. Introduction (1 point) Did you briefly introduce yourself? Did yo...
Lab8 teja0007
#2 It displays help about Windows PowerShell cmdlets and concepts. %4 Output of the Get-Volume command for the drive M: ...
08
...
Ignacio Film Review
What part of Ignatius’ life were you able to relate the most? Why? I could relate Ignacio’s hopelessness after his leg...