Course Hero Logo
Upload to Study
Expert Help

We must collect all the related columns in one table

Doc Preview
Pages 14
Identified Q&As 3
Total views 100+
we must collect all the related columns in one table, but without duplicated group. Also, we must implement the primary keys in their locations. Every column has unique value, and must not have the null value. 2NFis the Second Normal Form, which is the second step of the normalization, and it is built on the First Normal Form. all the 2NF tables are functionally dependent on the primary key.
Assignment 5: Tour Operator Agency Database3 3NFis the Third normal form that is the third step in the normalizing, and it builds on the first and second normal forms. In this step, we must released all the tables that are not depending on the primary keys. Or, we must put all the foreign keys columns. (Janssen, C., 2014). Now, we will see the normalization steps in the following drawing: 1. All the tables before the normalization: 2. The First Normal Form:
Assignment 5: Tour Operator Agency Database4 3. The Second Normal Form:
Assignment 5: Tour Operator Agency Database5 Create the naming conventions for each entity and attributes:
Assignment 5: Tour Operator Agency Database6 The first Entity: (TOUR) The Second Entity: (SSLESPERSON)
Assignment 5: Tour Operator Agency Database7 The third Entity: (TOURSOLD) The fourth Entity: (CUSTOMER)
Assignment 5: Tour Operator Agency Database8 The tables with an Entity Relationship Model (ERM):
Assignment 5: Tour Operator Agency Database9
Assignment 5: Tour Operator Agency Database10 The query of (how many days the customer’s invoice will require payment if total amount due is within 45 days): Here we must add the new columns (INVOICEDATE) and (DUEDATE) to the previous (TOURSOLD) table, and then make the query, as the following: ALTERTABLE PUBLIC.TOURSOLD,ADDINVICEDATE; ALTERTABLE PUBLIC.TOURSOLD, ADDDUEDATE; SELECTINVOICEDATEFROMPUBLIC.TOURSOLD,WHERE[INVOICEDATE] + 45 AS [DUEDATE];
Course Hero Badge

Want to read all 14 pages?

Previewing 11 of 14 pages Upload your study docs or become a member.
Course Hero Badge

Want to read all 14 pages?

Previewing 11 of 14 pages Upload your study docs or become a member.
Course Hero Badge

End of preview

Want to read all 14 pages? Upload your study docs or become a member.