Solved by Expert Tutors
Discuss what normalization is and why it is important. Normalize the database design in Module 2, and describe whether the tables are all...
Solved by Expert Tutors
Question

Good Afternoon Everyone!

I was wondering if I could get some help with these computer science database principles. Thank you in advance for the assistance!

NORMALIZATION AND SQL DDL STATEMENTS Case Assignment In this assignment, you are expected to accomplish the following: Discuss what normalizaTon is and why it is important. Normalize the database design in Module 2, and describe whether the tables are all normalized. Explain whether the tables saTsfy the requirements of 1NF, 2NF, and 3NF. If you believe your tables as submi±ed in Case 2 are already normalized, explain in your paper how those tables meet the normalizaTon standards. If not, how you would modify the design? Draw or describe your new database ERD the same way you did in Module 2 in the paper. Describe (in at least one paragraph) what ACID is and why it is important for databases. Describe (in at least a half page) why normalizaTon is needed and how to opTmize it. Describe lessons learned from this exercise. Include in the paper the SQL statements used for creaTng tables and screenshots of the results in your chosen DBMS. Assignment Expecta±ons Normalize tables in a database design. Be able to use SQL to create tables and indexes. Brie²y discuss the pros and cons of normalizaTon. Tables in an Electronics Store ³he Electronic Store data base is composed of three tables: Customer, Employee and SalesOrder. ³he a±ributes of these tables are shown as below:
Background image of page 01
SQL> create table Employee (SocialSecurityNumbernumber(5) primary key, FName varchar2(15), LName varchar2(15), AddressLine1 varchar2(50), AddressLine2 varchar2(15), city varchar2(15),state varchar2(3), phone varchar2(15), email varchar2(15), zipcode varchar2(15)); Output: Table created. SQL> desc Employee; Output: Name Null? Type ----------------------------------------- -------- ----------------------------------------------- SOCIALSECURITYNUMBER NOT NULL NUMBER(5) FNAME VARCHAR2(15) LNAME VARCHAR2 (15) ADDRESLINE1 VARCHAR2 (50) ADDRESLINE2 VARCHAR2 (15) CITY VARCHAR2 (15) STATE VARCHAR2 (3) PHONE VARCHAR2 (15) ZIPCODE VARCHAR2 (15) EMAILID VARCHAR2 (15) SQL> create table Employee (SocialSecurityNumbernumber(5) primary key, FName varchar2(15), LName varchar2(15), AddressLine1 varchar2(50), AddressLine2 varchar2(15), city varchar2(15),state varchar2(3), phone varchar2(15), email varchar2(15), zipcode varchar2(15)); Output: Table created. SQL> desc Employee; Output: Name Null? Type
Background image of page 02
Show entire document
Sign up to view the entire interaction

Step-by-step answer

s ante, dapibus a molestie consequat, ultrices ac

congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui

Computer Help 1 - Answer.docx
amet, consect amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. sus ante, dapibus a molestie consequat, ultrices ac mag usce dui lectus, congue vel laoreet ac, dictum vita

Subscribe to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Let our 24/7 Computer Science tutors help you get unstuck! Ask your first question.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes