Lab 1 - Books Galore - Saved to this PC Heb Help Acrobat Ptal me what you will no lonke Galerie - Saved to = 2 R Acrobat Tell me what you want to do TP Find bccc c AABBcco - - Reple 1 Heading 1 1 Heading 2 T Normal T No Spac... Title Subtitle Subtle Em... Emphasis intense E. Strong Quote Intense ... Subtle Ret. A selec & Editing . .. ... Marks: 8% (marked out of 26) LATE LABS WILL NOT BE ACCEPTED A 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 SNF. 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 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 database for the new computer system. The book store employs several employees The Task: You are to design a relational database, in 3d normal form, that conforms to the specifications described in the following pages. Our scope is limited to the views given in the lab. 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 omestions regarding the business asnects of this comnany. Additional information LL Lab 1 - Books Galore - Saved to this PC Acrobat Tell me what you want to do AaBBC AaBbCD AaBbCD AaBhCD AaB AaBbccc AaBbCcDc AabCcDc AaB CcDc AaBbCcDd AaBbCD AaBb C 1 Heading 1 Heading 2 1 Normal 1 No Spac. Title Subtitle Subtle Em. Emphasis Intense E. Strong Quote Intense Q.- Styles Employee View: 16 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 Author Name Mary Writer Susie Type 232 Category Code Category Description Romance e w DLL Lab 1 - Books Galore - Saved to this PC Help Acrobat Tell me what you want to do 2+ . AaBBC AaBbc ABCD ABCD AaB Aabbcc ABCDe ABCDE ABCDC ABCDe AaB CD ABCD AABECCDI Heading 1 Heading 2 1 Normal 1 No Spac.. Title Subtitle Subtle Em Emphasis intense Strang Q uote Intense Subtle Refu 5 Styles Sale View: (9 marks) An invoice is created for each customer detailing their purchase and how much they owe. Books Galore 4 Sale Number: 3002 Date: Jan 11, 2011 Customer Bob Brown Customer No: 502 12222 - 66 Street Edmonton, Alta. T5J 1X1 Employee: Jason Readaint 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: OST: Total: $245.00 312.25 $257.25 Merged ERD (2 marks) Submission Requirements Your lab submission must include a professional looking printed document in a duo tang containing A 3NF solution for each view showing all the attributes and entities as they appear in the initial table. 1NF 2NF and 3NF Use bold to indicate primary key attributes and italics to identity 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: o About what you liked/disliked about the lab o How long it took you to complete the lab How prepared you felt you were for the lab o Recommendations for future labs (if any) . Any additional requirements as specified by your instructor He w Lab 1 - Books Galore - Saved to this PC Heb Help Acrobat Ptal me what you will no lonke Galerie - Saved to = 2 R Acrobat Tell me what you want to do TP Find bccc c AABBcco - - Reple 1 Heading 1 1 Heading 2 T Normal T No Spac... Title Subtitle Subtle Em... Emphasis intense E. Strong Quote Intense ... Subtle Ret. A selec & Editing . .. ... Marks: 8% (marked out of 26) LATE LABS WILL NOT BE ACCEPTED A 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 SNF. 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 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 database for the new computer system. The book store employs several employees The Task: You are to design a relational database, in 3d normal form, that conforms to the specifications described in the following pages. Our scope is limited to the views given in the lab. 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 omestions regarding the business asnects of this comnany. Additional information LL Lab 1 - Books Galore - Saved to this PC Acrobat Tell me what you want to do AaBBC AaBbCD AaBbCD AaBhCD AaB AaBbccc AaBbCcDc AabCcDc AaB CcDc AaBbCcDd AaBbCD AaBb C 1 Heading 1 Heading 2 1 Normal 1 No Spac. Title Subtitle Subtle Em. Emphasis Intense E. Strong Quote Intense Q.- Styles Employee View: 16 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 Author Name Mary Writer Susie Type 232 Category Code Category Description Romance e w DLL Lab 1 - Books Galore - Saved to this PC Help Acrobat Tell me what you want to do 2+ . AaBBC AaBbc ABCD ABCD AaB Aabbcc ABCDe ABCDE ABCDC ABCDe AaB CD ABCD AABECCDI Heading 1 Heading 2 1 Normal 1 No Spac.. Title Subtitle Subtle Em Emphasis intense Strang Q uote Intense Subtle Refu 5 Styles Sale View: (9 marks) An invoice is created for each customer detailing their purchase and how much they owe. Books Galore 4 Sale Number: 3002 Date: Jan 11, 2011 Customer Bob Brown Customer No: 502 12222 - 66 Street Edmonton, Alta. T5J 1X1 Employee: Jason Readaint 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: OST: Total: $245.00 312.25 $257.25 Merged ERD (2 marks) Submission Requirements Your lab submission must include a professional looking printed document in a duo tang containing A 3NF solution for each view showing all the attributes and entities as they appear in the initial table. 1NF 2NF and 3NF Use bold to indicate primary key attributes and italics to identity 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: o About what you liked/disliked about the lab o How long it took you to complete the lab How prepared you felt you were for the lab o Recommendations for future labs (if any) . Any additional requirements as specified by your instructor He w