CIS 515 Week 5 Assignment

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 2^nd 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

 

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

$40.00 – Purchase Checkout Added to cart