MIT1_204S10_quiz01_sol

MIT1_204S10_quiz01_sol - 1.204 Quiz 1 Spring 2010 Solutions...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Quiz 1 Spring 2010 Solutions 1. Data model (35 points) SalesType SalesTypeDesc SalesType ProductID SalesType (FK) (IE) Product ProductID (FK) GliderDesc GliderType (FK) (IE) Glider ProductID (FK) AssemblyDesc Assembly GliderType GliderTypeDesc GliderType VendorAssembly Vendor VendorID VendorID (FK) VendorName ProductID (FK) VendorAssemblyID VendorAssemblyDesc VendorAssemblyPrice 2. Database/SQL. (30 points) Based on the data model in question 2, you construct a database where the tables, attributes and relationships correspond exactly to the data model structure. You are now asked to write the following SQL queries against your database. a. List the name and vendor ID of all vendors that supply at least one assembly to MITG. List each vendor only once. (10 points) SELECT DISTINCT Vendor.VendorName, Vendor.VendorID FROM Vendor, VendorAssembly WHERE Vendor.VendorID= VendorAssembly.VendorID; b. List the product ID and glider description of all high performance hang gliders with a wholesale
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 4

MIT1_204S10_quiz01_sol - 1.204 Quiz 1 Spring 2010 Solutions...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online