This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: 7.104 DATABASE ENGI NEER I NG I WEEK 04 – AM08 LAB / TUT DATABASE DESIGN USING NORMAL IZAT ION This laboratory / tutorial exercise aims for the student to understand and gain skills on how to design database using normalization. Student also needs to create SQL Queries to check table structure and other information for designing a new database system. I t is recommended for students to follow the order as listed below; SKU SKU_Description Department Buyer DeptBudgetCode 100100 Std.Scuba Tank, yellow Water Sports Pete Hansen BC-100 100200 Std. Scuba Tank, Magenta Water Sports Pete Hansen BC-100 101100 Dive Mask, Small Clear Water Sports Nancy Meyers BC-100 101200 Dive Mask, Med Clear Water Sports Nancy Meyers BC-100 201000 Half-dome Tent Camping Cindy Lo BC-200 202000 Half-dome Tent Footprint Camping Cindy Lo BC-200 301000 Light Fly Climbing Harness Climbing Jerry Martin BC-300 302000 Locking carabiner, Oval Climbing Jerry Martin BC-300 (Table SKU_DATA03) (A) SQL Server 2008 Database System...
View Full Document
- Spring '11
- Microsoft SQL Server, Water Sports Water, Sports Water Sports