4:00 OMN. al 76% Lab 1 - Books Galore - Saved the O pened to the Businea CartartKalan is the Tgl 1 marka will be the code the 4:00 DON 3.dll 76% Lab 1 - Books Galore - Saved S et is kept on la forchetuplapes. It cum e adar na tha gehad Oy E-Mail Adresse to the app The Employee Book Title Vira l Anther Code Male View KEI sidor d e particed how much they Books Galore Date J . 2011 4:00 DO. $ 3.76% Lab 1 - Books Galore - Saved Category Code Category Description Books Galore Marged CRD: (2 marks] on include a looking prind docena dusung con 3 of 3 Lab 1 - Books Galore - Saved to this PC Help Help Acrobat Acrobat P tel me what you need to be looks Gilbere Suwed to this PC Tell me what you want to do 1 2! 2. AaBb C AaBbce AaBbCD ABCD Aab AaBbcc4aBb CcDe AaB CeDc4a8bCcDc ABCcDd ABCD ABCD AABBCCD T Heading 1 1 Heading 2 1 Normal No Spac... Title Subtitle Subtle Em... Emphasis intense E. Strong Quote Intense 0. Subtle Ret... Styles DMIT1508 Lab 1 Due by: January 31" by 10:15 am Marks: 8% (marked out of 26) LATE LABS WILL NOT BE ACCEPTED Books Galore Objectives: 1. Produce an ERD in 3NF from source documents and client input. 2. Demonstrate first, second, and third normal forms by showing the entities as they exist in each of the three normal forms 3. Merge ERD's from different views to create one ERD Requirements: Given the source documents and company description create a database desin demonstrating the concept of normalization, showing the database tables in 1NF, 2NF, and 3NE. You will do this for each of the three views and create an ERD for each view in 3NE, as well as an ERD of the final merged solution (4 total). All ERD's must be created using Microsoft Visio or a tool approved by your instructor The Problem: Dick and Jane own Books Galore. Their company is so successful that they need to move from a manual system to a computer-based system. We would like you to design a database for the new computer system. The book store employs several employees. The Task: You are to design a relational database, in 3rd normal form, that conforms to the specifications described in the following pages. Our scope is limited to the views given in the lab. e : Rneineee Contact R e w DOLL Lab 1 - Books Galore - Saved to this PC Help Acrobat Tell me what you want to do 21 AaBb C AalbCcb ABCD AaBbCD AaB AalbCcCabe Heading Heading 2 1 Normal 1 No Spac... Title Subtitle Subtle Em... 2 . dabcDc AaBoCcDE ABCD. AaBBCD AaBbce AABECCDI Emphasis intense E... Strong Quote Intense. Subtle Ref... Styles Employee View: (6 marks) An employee document is kept on file for each employee. It currently looks similar to the following: Employee Number: 912 SIN: 444 555 666 Employee Group Code: S Name: Jason Readalot Employee Group Name: Sales Address: 4567 - 89 Ave Wage: $16 City: Edmonton, Alta Postal Code: TSN 1R1 Work Phone: 432-4444 E-Mail Address: JasonRox@hotmail.com Each employee belongs to a staff group. The Employee group an employee belongs to defines their wage Book Title View: (9 marks) A document is kept for each book the store sells. It contains information about the title itself as well as publisher, author and category details for the title. One publisher publishes a book A book can have many authors . A book is in only one category ISBN: 0-7356-1374-5 Title: How I fell in love with Normalization Suggested Selling Price: 48.00 Quantity On Hand: 6 Publisher Code 134 Publisher Name Microsoft Press Author Code 423 232 Author Name Mary Writer Susie Type Category Code Category Description Romance 9 e w DLL Lab 1 - Books Galore - Saved to this PC Help Acrobat Tell me what you want to do 2 1 - AaBb C AaBbced ABCD AaBbCcD HAD AaBbcc AmBoCcDc AaB CeDe daBtCcDc ABC De AaBbCD ABCD AABECCDI 1 Heading 1 1 Heading 2 1 Normal No Spac... Title Subtitle Subtle Em... Emphasis intense E. Strong Quote Intense Q. Subtle Ref.. Styles Sale View: (9 marks) An invoice is created for each customer detailing their purchase and how much they owe. Books Galore Sale Number: 3002 Date: Jan 11, 2011 Customer: Bob Brown Customer No: 502 12222-66 Street Edmonton, Alta. TS 1X1 Employee: Jason Rcadalot Employee No: 301 Quantity ISBN Book Title 0-7356 1374 5 SQL and me 0-8888-1234-5 Normalization for Dummies 0-1234-1234-6 Case of the Missing Attributes Price 40.00 30.00 145.00 Amount $40.00 $60.00 $145.00 Sub Total: GST: Total: $245.00 $12.25 $257.25 Merged ERD. (2 marks) Submission Requirements Your lab submission must include a professional looking printed document in a duo tang containing: A3NF solution for each view showing all the attributes and entities as they appear in the initial table. 1NE. 2NE. and 3NF Use bold to indicate primary key attributes and italics to identify foreign key attributes (or another method if approved by your instructor) An ERD for each 3NF solution of each view and an ERD of the merged solution (4 ERD's total) created with an ERD modeling tool approved by your instructor (Visio, LucidChart, etc.). A title page containing the lab number and title, your name, instructor name, and section number. A short discussion about the lab including About what you liked/disliked about the lab How long it took you to complete the lab How prepared you felt you were for the lab 0 Recommendations for future labs (if any) Any additional requirements as specified by your instructor DEL 4:00 OMN. al 76% Lab 1 - Books Galore - Saved the O pened to the Businea CartartKalan is the Tgl 1 marka will be the code the 4:00 DON 3.dll 76% Lab 1 - Books Galore - Saved S et is kept on la forchetuplapes. It cum e adar na tha gehad Oy E-Mail Adresse to the app The Employee Book Title Vira l Anther Code Male View KEI sidor d e particed how much they Books Galore Date J . 2011 4:00 DO. $ 3.76% Lab 1 - Books Galore - Saved Category Code Category Description Books Galore Marged CRD: (2 marks] on include a looking prind docena dusung con 3 of 3 Lab 1 - Books Galore - Saved to this PC Help Help Acrobat Acrobat P tel me what you need to be looks Gilbere Suwed to this PC Tell me what you want to do 1 2! 2. AaBb C AaBbce AaBbCD ABCD Aab AaBbcc4aBb CcDe AaB CeDc4a8bCcDc ABCcDd ABCD ABCD AABBCCD T Heading 1 1 Heading 2 1 Normal No Spac... Title Subtitle Subtle Em... Emphasis intense E. Strong Quote Intense 0. Subtle Ret... Styles DMIT1508 Lab 1 Due by: January 31" by 10:15 am Marks: 8% (marked out of 26) LATE LABS WILL NOT BE ACCEPTED Books Galore Objectives: 1. Produce an ERD in 3NF from source documents and client input. 2. Demonstrate first, second, and third normal forms by showing the entities as they exist in each of the three normal forms 3. Merge ERD's from different views to create one ERD Requirements: Given the source documents and company description create a database desin demonstrating the concept of normalization, showing the database tables in 1NF, 2NF, and 3NE. You will do this for each of the three views and create an ERD for each view in 3NE, as well as an ERD of the final merged solution (4 total). All ERD's must be created using Microsoft Visio or a tool approved by your instructor The Problem: Dick and Jane own Books Galore. Their company is so successful that they need to move from a manual system to a computer-based system. We would like you to design a database for the new computer system. The book store employs several employees. The Task: You are to design a relational database, in 3rd normal form, that conforms to the specifications described in the following pages. Our scope is limited to the views given in the lab. e : Rneineee Contact R e w DOLL Lab 1 - Books Galore - Saved to this PC Help Acrobat Tell me what you want to do 21 AaBb C AalbCcb ABCD AaBbCD AaB AalbCcCabe Heading Heading 2 1 Normal 1 No Spac... Title Subtitle Subtle Em... 2 . dabcDc AaBoCcDE ABCD. AaBBCD AaBbce AABECCDI Emphasis intense E... Strong Quote Intense. Subtle Ref... Styles Employee View: (6 marks) An employee document is kept on file for each employee. It currently looks similar to the following: Employee Number: 912 SIN: 444 555 666 Employee Group Code: S Name: Jason Readalot Employee Group Name: Sales Address: 4567 - 89 Ave Wage: $16 City: Edmonton, Alta Postal Code: TSN 1R1 Work Phone: 432-4444 E-Mail Address: JasonRox@hotmail.com Each employee belongs to a staff group. The Employee group an employee belongs to defines their wage Book Title View: (9 marks) A document is kept for each book the store sells. It contains information about the title itself as well as publisher, author and category details for the title. One publisher publishes a book A book can have many authors . A book is in only one category ISBN: 0-7356-1374-5 Title: How I fell in love with Normalization Suggested Selling Price: 48.00 Quantity On Hand: 6 Publisher Code 134 Publisher Name Microsoft Press Author Code 423 232 Author Name Mary Writer Susie Type Category Code Category Description Romance 9 e w DLL Lab 1 - Books Galore - Saved to this PC Help Acrobat Tell me what you want to do 2 1 - AaBb C AaBbced ABCD AaBbCcD HAD AaBbcc AmBoCcDc AaB CeDe daBtCcDc ABC De AaBbCD ABCD AABECCDI 1 Heading 1 1 Heading 2 1 Normal No Spac... Title Subtitle Subtle Em... Emphasis intense E. Strong Quote Intense Q. Subtle Ref.. Styles Sale View: (9 marks) An invoice is created for each customer detailing their purchase and how much they owe. Books Galore Sale Number: 3002 Date: Jan 11, 2011 Customer: Bob Brown Customer No: 502 12222-66 Street Edmonton, Alta. TS 1X1 Employee: Jason Rcadalot Employee No: 301 Quantity ISBN Book Title 0-7356 1374 5 SQL and me 0-8888-1234-5 Normalization for Dummies 0-1234-1234-6 Case of the Missing Attributes Price 40.00 30.00 145.00 Amount $40.00 $60.00 $145.00 Sub Total: GST: Total: $245.00 $12.25 $257.25 Merged ERD. (2 marks) Submission Requirements Your lab submission must include a professional looking printed document in a duo tang containing: A3NF solution for each view showing all the attributes and entities as they appear in the initial table. 1NE. 2NE. and 3NF Use bold to indicate primary key attributes and italics to identify foreign key attributes (or another method if approved by your instructor) An ERD for each 3NF solution of each view and an ERD of the merged solution (4 ERD's total) created with an ERD modeling tool approved by your instructor (Visio, LucidChart, etc.). A title page containing the lab number and title, your name, instructor name, and section number. A short discussion about the lab including About what you liked/disliked about the lab How long it took you to complete the lab How prepared you felt you were for the lab 0 Recommendations for future labs (if any) Any additional requirements as specified by your instructor DEL