Solved by Expert Tutors
Improving Database Design Improving Database Design through Normalization Continue improving the bookstore database (tables) you designed. Here are...
Solved by Expert Tutors
Question

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

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 2 - Answer.docx
Donec aliquet. Lorem ipsum dolor sit amet tesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat Fusce dui lectus, congue vel la m ipsum dolor sit amet, consectetur adipisci

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