Lab 1 - Books Galore - Saved to this PC Acrobat Tell me what you want to do . 1 Heading 1 Heading 2 1 Normal 1 No Spac.. Title Subtitle Subtle Em... Emphasis Intense E... Strong Quote Intense Q... Styles DMIT 1508 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 design demonstrating the concept of normalization, showing the database tables in 1NF, 2NF, and 3NF. You will do this for each of the three views and create an ERD for each view in 3NF, 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. for each : All ERD's your instru 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. neinage Cont DELL Lab 1 - Books Galore - Saved to this PC Help Acrobat Tell me what you want to do 3. . et | AB ec AcB ABBC 1 Heading 1 Heading 2 Normal 1 No Spac. Title Subtitle Subtle Em... Emphasis Intense E. Strong Quote Intense Q.. Subtle Ref... = 2 . Styles Business Contact/Rules: Your instructor will answer questions about any information that is not included in this document or to clarify. It is good client communication to review the documents given to you before asking the client a question that is answered on those documents. They can only answer questions regarding the business aspects of this company. Additional information about the company is described in each view. 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 Readalet Employce Group Name: Sales Address: 4567 - 89 Ave Wage: $16 City: Edmonton, Alta Postal Codes TSN IRI Works Phone: 432 4444 E-Mail Address: Jason Rox@hotmail.com Each employee belongs to a stafl group. The Employee group an employee belongs to defines their wage Book Title View: 19 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 . Abool can have many authors A book is in only one category DELL Lab 1 - Books Galore - Saved to this PC Help Acrobat Tell me what you want to do a 3. 6 cn | bccc . ABBccp Heading 1 T Heading 2 1 Normal 1 No Spac. Title Subtitle Subtle Em... Emphasis intense E. Strong Quote intense Q... Subtle Ref... Styles E 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 Sade View: 19 marles) An invoice is created for each customer detailing their purchase and how much they owe. Books Galore Sale Number 3002 Customer Bob Brown Date: Jan 11, 2011 Customer No. 502 a e DELL Lab 1 - Books Galore - Saved to this PC ew Help Acrobat Tell me what you want to do AaBb C AaBb C ABCD ABCD Aab AaBbccc da CD AaBoCeDe daB.CD. AaBbCcDd AaB CD ABCD AL Heading 11 Heading 2 T Normal 1 No Spac. Title Subtitle Subtle Em.. Emphasis intense E. Strong Quote intense O.. Sub . . . 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 No: 502 Customer: Bob Brown 12222-66 Street Edmonton, Alta. T5J 1X1 Employee: Jason Readalot Employee No: 301 ISBN Book Title 0-7356-1374-5 SOL 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 Quantity 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 tablo INF 2NF, 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 Recommendations for future labs (if any) Any additional requirements as specified by your instructor DELL Lab 1 - Books Galore - Saved to this PC Acrobat Tell me what you want to do . 1 Heading 1 Heading 2 1 Normal 1 No Spac.. Title Subtitle Subtle Em... Emphasis Intense E... Strong Quote Intense Q... Styles DMIT 1508 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 design demonstrating the concept of normalization, showing the database tables in 1NF, 2NF, and 3NF. You will do this for each of the three views and create an ERD for each view in 3NF, 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. for each : All ERD's your instru 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. neinage Cont DELL Lab 1 - Books Galore - Saved to this PC Help Acrobat Tell me what you want to do 3. . et | AB ec AcB ABBC 1 Heading 1 Heading 2 Normal 1 No Spac. Title Subtitle Subtle Em... Emphasis Intense E. Strong Quote Intense Q.. Subtle Ref... = 2 . Styles Business Contact/Rules: Your instructor will answer questions about any information that is not included in this document or to clarify. It is good client communication to review the documents given to you before asking the client a question that is answered on those documents. They can only answer questions regarding the business aspects of this company. Additional information about the company is described in each view. 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 Readalet Employce Group Name: Sales Address: 4567 - 89 Ave Wage: $16 City: Edmonton, Alta Postal Codes TSN IRI Works Phone: 432 4444 E-Mail Address: Jason Rox@hotmail.com Each employee belongs to a stafl group. The Employee group an employee belongs to defines their wage Book Title View: 19 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 . Abool can have many authors A book is in only one category DELL Lab 1 - Books Galore - Saved to this PC Help Acrobat Tell me what you want to do a 3. 6 cn | bccc . ABBccp Heading 1 T Heading 2 1 Normal 1 No Spac. Title Subtitle Subtle Em... Emphasis intense E. Strong Quote intense Q... Subtle Ref... Styles E 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 Sade View: 19 marles) An invoice is created for each customer detailing their purchase and how much they owe. Books Galore Sale Number 3002 Customer Bob Brown Date: Jan 11, 2011 Customer No. 502 a e DELL Lab 1 - Books Galore - Saved to this PC ew Help Acrobat Tell me what you want to do AaBb C AaBb C ABCD ABCD Aab AaBbccc da CD AaBoCeDe daB.CD. AaBbCcDd AaB CD ABCD AL Heading 11 Heading 2 T Normal 1 No Spac. Title Subtitle Subtle Em.. Emphasis intense E. Strong Quote intense O.. Sub . . . 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 No: 502 Customer: Bob Brown 12222-66 Street Edmonton, Alta. T5J 1X1 Employee: Jason Readalot Employee No: 301 ISBN Book Title 0-7356-1374-5 SOL 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 Quantity 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 tablo INF 2NF, 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 Recommendations for future labs (if any) Any additional requirements as specified by your instructor DELL