View the step-by-step solution to:

NORMALIZATION AND SQL DDL STATEMENTS SLP Assignment Overview Developing a Database System: Improving Database Design Improving Database Design...

Good Afternoon Everyone!

I was wondering if I could receive some assistance with these Computer Science related topics at hand. Thank you in advance for the help!

NORMALIZATION AND SQL DDL STATEMENTS SLP Assignment Overview Developing a Database System: Improving Database Design Improving Database Design through NormalizaTon Contnue improving The booksTore daTabase (Tables) you designed. Here are your Tasks: 1. Normalize The Tables from The previous module. Discuss 1NF, 2NF and 3NF, and wheTher you believe your Tables satsfy each level of normal forms. If all your Tables have sats±ed The 3NF, explain The reason. 2. Drop The Tables no longer needed, and creaTe Tables as required in your new design, using SQL in DBMS. Include The SQL sTaTemenTs and screenshoTs of your new Tables in The paper. SLP Assignment Expecta±ons Normalize Tables in a daTabase design. Be able To creaTe and drop Tables using SQL. CommunicaTe e²ectvely wiTh your audience. 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: 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: ³able creaTed. SQL> desc Employee;
Background image of page 01
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 ----------------------------------------- -------- ----------------------------------------------- SOCIALSECURITYNUMBER NOT NULL NUMBER(5) FNAME VARCHAR2(15) LNAME VARCHAR2 (15) ADDRESLINE1 VARCHAR2 (50) ADDRESLINE2 VARCHAR2 (15) CITY VARCHAR2 (15)
Background image of page 02
Show entire document
Sign up to view the entire interaction

Top Answer

View the full answer
Computer Help 2 - Answer.docx

Normalization of database of previous task
The database designed in previous task is already normalized. It satisfies the
requirement of 1NF, 2NF and 3NF.
1NF: When there is no repetitive group of...

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