View the step-by-step solution to:

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

Top Answer

View the full answer
Computer Help 1 - Answer.docx

Normalization
Normalization is the concept of removing the redundancy from the database and
organizing the database to improve database operations.
If there is redundancy in the database and it is...

Sign up 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.

-

Educational Resources
  • -

    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
Ask a homework question - tutors are online