Lab7-Mistry

Lab7-Mistry Task 1: Perform normalization by writing UNF, 1NF, 2NF and 3NF for the following user views. StoreID StrName ManagerID MgrName ProductID PrdName PrdModel S101 North York M200 John Edwards 933517 Keyboard Model01 S101 North York M200 John Edwards 932215 Mouse Model02 S101 North York M200 John Edwards 975534 Monitor Model03 S102 Toronto M300 Don Smith 932215 Mouse Model02 S102 Toronto M300 Don Smith 933517 Keyboard Model01 S103 Scarborough M400 John Doe 942341 Camera Model04 S104 Scarborough M400 John Doe 942516 Charger Model05 UNF StoreI D StrName ManagerI D MgrName ProductID PrdName PrdModel S101 North York M200 John Edwards 933517 Keyboard Model101 S101 North York M200 John Edwards 932215 Mouse Model102 S101 North York M200 John Edwards 975534 Monitor Model103 S102 Toronto M300 Don Smith 932215 Mouse Model102 S102 Toronto M300 Don Smith 933517 Keyboard Model101 S103 Scarborough M400 John Doe 942341 Camera Model104 S104 Scarborough M400 John Doe 942516 Charger Model105 1NF Store Table StoreID StrName ManagerID MgrName S101 North York M200 John Edwards S102 Toronto M300 Don Smith S103 Scarborough M400 John Doe S104 Scarborough M400 John Doe

Product Table ProductID PrdName PrdModel 933517 Keyboard Model01 932215 Mouse Model02 975334 Monitor Model03 942341 Camera Model04 942516 Charger Model05 2NF Store Table StoreID StrName S101 North York S102 Toronto S103 Scarborough S104 Scarborough Manager Table ManagerID MgrName StoreID M200 John Edwards S101 M300 Don Smith S102 M400 John Doe S103 M400 John Doe S104 Product Table ProductID PrdName PrdModel 933517 Keyboard Model101 932215 Mouse Model102 975534 Monitor Model103 942341 Camera Model104 942516 Charger Model105 3NF Store Table StoreID StrName S101 North York S102 Toronto S103 Scarborough S104 Scarborough

Task 2: Convert the following relational model to star schema diagram

TASK 3: Use AdventureWorks2022 database and perform the following. a) Create a copy of Person.Person table using the script below: SELECT * INTO Person.PersonFALL2023 FROM Person.Person b) Create a nonclustered index on the table Person.PersonFALL2023 (on any column)

Submission: Use this document to write your answer for each task and save as lab7-yourlastname and submit it on Myseneca before due date.  Task 1: Complete normalization solution up to third normal form  Task 2: Star Schema diagram  Task 3: Screenshot of code with the output