Cis 515 Week 5 Assignment Essay

2000 Words May 30th, 2015 8 Pages
CIS 515 Week 5 Assignment https://hwguiders.com/downloads/cis-515-week-5-assignment/

Tours Company System – Database Implementation

Your Name
Your College
Your University
Date

A1 – a) Below is the data model for 2nd Normal form for travel company. Their table name and column names are mentioned in the table.
SalesPersonDetails
EmployeeId FirstName LastName ToursSold
Integer Text Text Integer

CustomersData
CustomerID CustomerName Address City State ZipCode
Integer Text Text Text Text Text

CustomerTourDetails
CustomerID TourID Numberof PersonsinTour TotalAmount
Paid
Integer Integer Integer Integer
…show more content…
Their table name and column names are mentioned in the table.
SalesPersonDetails
EmployeeId FirstName LastName ToursSold
Integer Text Text Integer

CustomersData
CustomerID CustomerName Address City State ZipCode
Integer Text Text Text Text Text

CustomerTourDetails
CustomerID TourID Numberof PersonsinTour TotalAmount
Paid
Integer Integer Integer Integer

TourDetails
TourSeason TourID TourRates PerPerson
Date Integer Integer Integer

A 1 – b)
Table Name: SalesPerson
Attributes: EmployeeID, FirstName, LastName, ToursSold Table Name: CustomersData
Attributes: CustomerID, CustomerName, Address, city, State, ZipCode For More Information hit Purchase Button to Get Your Assignment

CIS 515 Week 5 Assignment https://hwguiders.com/downloads/cis-515-week-5-assignment/

Tours Company System – Database

Related Documents