Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!

Entity Relationship Diagram For Normalisation

tag 1 Download12 Pages 2,914 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT
Samuel Barbera Student Reviews Student Reviews Student Reviews Student Reviews Student Reviews 4.8/5 hire me
Question: Discuss about the ERD for Normalization Functions.   Answer: ERD: Normalization: First Normalization Form: Eliminating repeating groups VIPStatus (VIPStatusID, VIPStatusName, DiscountPtge) Company (CompanyID, CompanyName, Address, Phone, Fax, Email) Customer (CustomerID, FirstName, LastName, Address, City, State, CompanyID, Mobile, PostCode, Email, CustomerTypeName, FFDiscount, VIPStatusID) Staff (StaffID, StaffName, Address, Phone, Email, SupervisorID, CompanyID) Location (LocationID, LocationName, State, City, PostCode) TravelBooking (TravelID, DepartureDate, ArrivalDate, OverallTravelAmount, CustomerID, StaffID, CompanyID, NumAdult, NumChild, InvoiceDate, TravelPackageAmount, IsAmountPaid, TravelPackageID, Description, PackageAmount, DatePkgIssued, DatePkgExpired, DepartingDate, ReturnDate, AirlineID, AirlineName, DepartureLocationID, DestinationLocationID, FlightID, FlightName, DateOfDeparture, DateOfArrival, CabinClass, AirlineCharges, HotelID, HotelName, LocationID, Phone) Second Normalization Form: Eliminating redundant data VIPStatus (VIPStatusID, VIPStatusName, DiscountPtge) Company (CompanyID, CompanyName, Address, Phone, Fax, Email) Customer (CustomerID, FirstName, LastName, Address, City, State, CompanyID, Mobile, PostCode, Email, CustomerTypeName, FFDiscount, VIPStatusID) Staff (StaffID, StaffName, Address, Phone, Email, SupervisorID, CompanyID) Location (LocationID, LocationName, State, City, PostCode) Hotels (HotelID, HotelName, LocationID, Phone) TravelPackage (TravelPackageID, Description, PackageAmount, DatePkgIssued, DatePkgExpired, DepartingDate, ReturnDate) Airline (AirlineID, AirlineName, DepartureLocationID, DestinationLocationID, FlightID, FlightName, DateOfDeparture, DateOfArrival, CabinClass, AirlineCharges) TravelBooking (TravelID, DepartureDate, ArrivalDate, OverallTravelAmount, CustomerID, StaffID, CompanyID, NumAdult, NumChild, InvoiceDate, TravelPackageAmount, IsAmountPaid, TravelPackageID, AirlineID, HotelID) Third Normalization Form: Remove Transitive Dependency CustomerType (CustomerTypeID, CustomerTypeName) Company (CompanyID, CompanyName, Address, Phone, Fax, Email) Customer (CustomerID, FirstName, LastName, Address, City, State, CompanyID, Mobile, PostCode, Email, CustomerTypeID) Staff (StaffID, StaffName, Address, Phone, Email, SupervisorID, CompanyID)               VIPStatus (VIPStatusID, VIPStatusName, DiscountPtge) VIP (CustomerID, VIPStatusID)               FrequentFlyer (CustomerID, FFDiscount) Location (LocationID, LocationName, State, City, PostCode) Flight (FlightID, FlightName) Hotels (HotelID, HotelName, LocationID, Phone) TravelPackage (TravelPackageID, Description, PackageAmount, DatePkgIssued, DatePkgExpired, DepartingDate, ReturnDate) Airline (AirlineID, AirlineName, DepartureLocationID, DestinationLocationID, FlightID, DateOfDeparture, DateOfArrival, CabinClass, AirlineCharges) TravelBooking (TravelID, DepartureDate, ArrivalDate, OverallTravelAmount, CustomerID, StaffID, CompanyID, NumAdult, NumChild) TravellingDetails (TravelPackageID, AirlineID, TravelID)               StayAt (HotelID, TravelID, TravelPackageID) Invoice (InvoiceID, InvoiceDate, TravelPackageAmount, IsAmountPaid, TravelID, CustomerID) Note:                 Primary Key        -              Underline                 Foreign Key        -              Italics Relational Schema: CustomerType (CustomerTypeID, CustomerTypeName)                 Primary Key (CustomerTypeID) Company (CompanyID, CompanyName, Address, Phone, Fax, Email)                 Primary Key (CompanyID) Customer (CustomerID, FirstName, LastName, Address, City, State, CompanyID, Mobile, PostCode, Email, CustomerTypeID)                 Primary Key (CustomerID),                 Foreign Key (CompanyID) References Company (CompanyID),                 Foreign Key (CustomerTypeID) References CustomerType (CustomerTypeID) Staff (StaffID, StaffName, Address, Phone, Email, SupervisorID, CompanyID)                 Primary Key (StaffID),                 Foreign Key (SupervisorID) References Staff (StaffID),                 Foreign Key (CompanyID) References Company (CompanyID)               VIPStatus (VIPStatusID, VIPStatusName, DiscountPtge)                 Primary Key (VIPStatusID) VIP (CustomerID, VIPStatusID)                 Primary Key (CustomerID),                 Foreign Key (CustomerID) References Customer (CustomerID)                 Foreign Key (VIPStatusID) References VIPStatus (VIPStatusID)               FrequentFlyer (CustomerID, FFDiscount)                 Primary Key (CustomerID),                 Foreign Key (CustomerID) References Customer (CustomerID) Location (LocationID, LocationName, State, City, PostCode)                 Primary Key (LocationID) Flight (FlightID, FlightName)                 Primary Key (FlightID) Hotels (HotelID, HotelName, LocationID, Phone)                 Primary Key (HotelID),                 Foreign Key (LocationID) References Location (LocationID) TravelPackage (TravelPackageID, Description, PackageAmount, DatePkgIssued, DatePkgExpired, DepartingDate, ReturnDate)                 Primary Key (TravelPackageID) Airline (AirlineID, AirlineName, DepartureLocationID, DestinationLocationID, FlightID, DateOfDeparture, DateOfArrival, CabinClass, AirlineCharges)                 Primary Key (RestaurantID),                 Foreign Key (DepartureLocationID) References Location (LocationID),                 Foreign Key (DestinationLocationID) References Location (LocationID),                 Foreign Key (FlightID) References Flight (FlightID) TravelBooking (TravelID, DepartureDate, ArrivalDate, OverallTravelAmount, CustomerID, StaffID, CompanyID, NumAdult, NumChild)                 Primary Key (TravelID),                 Foreign Key (CustomerID) References Customer (CustomerID),                 Foreign Key (StaffID) References Staff (StaffID),                 Foreign Key (CompanyID) References Company (CompanyID) TravellingDetails (TravelPackageID, AirlineID, TravelID)                 Primary Key (TravelPackageID, AirlineID, TravelID),                 Foreign Key (TravelPackageID) References TravelPackage (TravelPackageID),                 Foreign Key (AirlineID) References Airline (AirlineID),                 Foreign Key (TravelID) References TravelBooking (TravelID)               StayAt (HotelID, TravelID, TravelPackageID)                 Primary Key (TravelPackageID, AirlineID, TravelID),                 Foreign Key (TravelPackageID) References TravelPackage (TravelPackageID),                 Foreign Key (HotelID) References Hotels (HotelID),                 Foreign Key (TravelID) References TravelBooking (TravelID) Invoice (InvoiceID, InvoiceDate, TravelPackageAmount, IsAmountPaid, TravelID, CustomerID)                   Primary Key (InvoiceID),                 Foreign Key (TravelID) References TravelBooking (TravelID),                 Foreign Key (CustomerID) References Customer (CustomerID) Database Schema: DROP TABLE IF EXISTS CustomerType ; CREATE TABLE IF NOT EXISTS CustomerType (   CustomerTypeID INT NOT NULL,   CustomerTypeName VARCHAR(45) NOT NULL,   PRIMARY KEY (CustomerTypeID)); -- ----------------------------------------------------- -- Table Company -- ----------------------------------------------------- DROP TABLE IF EXISTS Company ; CREATE TABLE IF NOT EXISTS Company (   CompanyID INT NOT NULL,   CompanyName VARCHAR(45) NOT NULL,   Address VARCHAR(60) NOT NULL,   Phone VARCHAR(15) NOT NULL,   Fax VARCHAR(15) NOT NULL,   Email VARCHAR(45) NOT NULL,   PRIMARY KEY (CompanyID)); -- ----------------------------------------------------- -- Table Customer -- ----------------------------------------------------- DROP TABLE IF EXISTS Customer ; CREATE TABLE IF NOT EXISTS Customer (   CustomerID INT NOT NULL,   FirstName VARCHAR(25) NOT NULL,   LastName VARCHAR(25) NOT NULL,   Address VARCHAR(60) NOT NULL,   City VARCHAR(30) NOT NULL,   State VARCHAR(3) NOT NULL,   Mobile VARCHAR(15) NOT NULL,   PostCode INT NOT NULL,   Email VARCHAR(45) NOT NULL,   CustomerTypeID INT NOT NULL,   CompanyID INT NOT NULL,   PRIMARY KEY (CustomerID),   INDEX fk_Customer_CustomerType_idx (CustomerTypeID ASC),   INDEX fk_Customer_Company1_idx (CompanyID ASC),   CONSTRAINT fk_Customer_CustomerType     FOREIGN KEY (CustomerTypeID)     REFERENCES CustomerType (CustomerTypeID)     ON DELETE NO ACTION     ON UPDATE NO ACTION,   CONSTRAINT fk_Customer_Company1     FOREIGN KEY (CompanyID)     REFERENCES Company (CompanyID)     ON DELETE NO ACTION     ON UPDATE NO ACTION); -- ----------------------------------------------------- -- Table Staff -- ----------------------------------------------------- DROP TABLE IF EXISTS Staff ; CREATE TABLE IF NOT EXISTS Staff (   StaffID INT NOT NULL,   StaffName VARCHAR(45) NOT NULL,   Address VARCHAR(60) NOT NULL,   Phone VARCHAR(15) NOT NULL,   Email VARCHAR(45) NOT NULL,   CompanyID INT NOT NULL,   SupervisorID INT NULL,   PRIMARY KEY (StaffID),   INDEX fk_Staff_Company1_idx (CompanyID ASC),   INDEX fk_Staff_Staff1_idx (SupervisorID ASC),   CONSTRAINT fk_Staff_Company1     FOREIGN KEY (CompanyID)     REFERENCES Company (CompanyID)     ON DELETE NO ACTION     ON UPDATE NO ACTION,   CONSTRAINT fk_Staff_Staff1     FOREIGN KEY (SupervisorID)     REFERENCES Staff (StaffID)     ON DELETE NO ACTION     ON UPDATE NO ACTION); -- ----------------------------------------------------- -- Table VIPStatus -- ----------------------------------------------------- DROP TABLE IF EXISTS VIPStatus ; CREATE TABLE IF NOT EXISTS VIPStatus (   VIPStatusID INT NOT NULL,   VIPStatusName VARCHAR(45) NOT NULL,   DiscountPtge FLOAT NOT NULL,   PRIMARY KEY (VIPStatusID)); -- ----------------------------------------------------- -- Table VIP -- ----------------------------------------------------- DROP TABLE IF EXISTS VIP ; CREATE TABLE IF NOT EXISTS VIP (   CustomerID INT NOT NULL,   VIPStatusID INT NOT NULL,   INDEX fk_VIP_Customer1_idx (CustomerID ASC),   INDEX fk_VIP_VIPStatus1_idx (VIPStatusID ASC),   PRIMARY KEY (CustomerID),   CONSTRAINT fk_VIP_Customer1     FOREIGN KEY (CustomerID)     REFERENCES Customer (CustomerID)     ON DELETE NO ACTION     ON UPDATE NO ACTION,   CONSTRAINT fk_VIP_VIPStatus1     FOREIGN KEY (VIPStatusID)     REFERENCES VIPStatus (VIPStatusID)     ON DELETE NO ACTION     ON UPDATE NO ACTION); -- ----------------------------------------------------- -- Table FrequentFlyer -- ----------------------------------------------------- DROP TABLE IF EXISTS FrequentFlyer ; CREATE TABLE IF NOT EXISTS FrequentFlyer (   CustomerID INT NOT NULL,   FFDiscount FLOAT NOT NULL,   INDEX fk_FrequentFlyer_Customer1_idx (CustomerID ASC),   PRIMARY KEY (CustomerID),   CONSTRAINT fk_FrequentFlyer_Customer1     FOREIGN KEY (CustomerID)     REFERENCES Customer (CustomerID)     ON DELETE NO ACTION     ON UPDATE NO ACTION); -- ----------------------------------------------------- -- Table Location -- ----------------------------------------------------- DROP TABLE IF EXISTS Location ; CREATE TABLE IF NOT EXISTS Location (   LocationID INT NOT NULL,   LocationName VARCHAR(45) NOT NULL,   City VARCHAR(30) NOT NULL,   State VARCHAR(3) NOT NULL,   PostCode INT NOT NULL,   PRIMARY KEY (LocationID)); -- ----------------------------------------------------- -- Table Flight -- ----------------------------------------------------- DROP TABLE IF EXISTS Flight ; CREATE TABLE IF NOT EXISTS Flight (   FlightID INT NOT NULL,   FlightName VARCHAR(45) NOT NULL,   PRIMARY KEY (FlightID)); -- ----------------------------------------------------- -- Table Hotels -- ----------------------------------------------------- DROP TABLE IF EXISTS Hotels ; CREATE TABLE IF NOT EXISTS Hotels (   HotelID INT NOT NULL,   HotelName VARCHAR(45) NOT NULL,   Phone VARCHAR(15) NOT NULL,   Location_LocationID INT NOT NULL,   PRIMARY KEY (HotelID),   INDEX fk_Hotels_Location1_idx (Location_LocationID ASC),   CONSTRAINT fk_Hotels_Location1     FOREIGN KEY (Location_LocationID)     REFERENCES Location (LocationID)     ON DELETE NO ACTION     ON UPDATE NO ACTION); -- ----------------------------------------------------- -- Table TravelPackage -- ----------------------------------------------------- DROP TABLE IF EXISTS TravelPackage ; CREATE TABLE IF NOT EXISTS TravelPackage (   TravelPackageID INT NOT NULL,   Description VARCHAR(60) NOT NULL,   PackageAmount FLOAT NOT NULL,   DatePkgIssued DATE NOT NULL,   DatePkgExpired DATE NOT NULL,   DepartingDate DATE NOT NULL,   ReturnDate DATE NOT NULL,   PRIMARY KEY (TravelPackageID)); -- ----------------------------------------------------- -- Table Airline -- ----------------------------------------------------- DROP TABLE IF EXISTS Airline ; CREATE TABLE IF NOT EXISTS Airline (   AirlineID INT NOT NULL,   AirlineName VARCHAR(45) NOT NULL,   DateOfDeparture DATE NOT NULL,   DateOfArrival DATE NULL,   CabinClass VARCHAR(30) NOT NULL,   AirlineCharges FLOAT NOT NULL,   DepartureLocationID INT NOT NULL,   DestinationLocationID INT NOT NULL,   FlightID INT NOT NULL,   PRIMARY KEY (AirlineID),   INDEX fk_Airline_Location1_idx (DepartureLocationID ASC),   INDEX fk_Airline_Location2_idx (DestinationLocationID ASC),   INDEX fk_Airline_Flight1_idx (FlightID ASC),   CONSTRAINT fk_Airline_Location1     FOREIGN KEY (DepartureLocationID)     REFERENCES Location (LocationID)     ON DELETE NO ACTION     ON UPDATE NO ACTION,   CONSTRAINT fk_Airline_Location2     FOREIGN KEY (DestinationLocationID)     REFERENCES Location (LocationID)     ON DELETE NO ACTION     ON UPDATE NO ACTION,   CONSTRAINT fk_Airline_Flight1     FOREIGN KEY (FlightID)     REFERENCES Flight (FlightID)     ON DELETE NO ACTION     ON UPDATE NO ACTION); -- ----------------------------------------------------- -- Table TravelBooking -- ----------------------------------------------------- DROP TABLE IF EXISTS TravelBooking ;   CREATE TABLE IF NOT EXISTS TravelBooking (   TravelID INT NOT NULL,   DepartureDate DATE NOT NULL,   ArrivalDate DATE NOT NULL,   OverallTravelAmount FLOAT NOT NULL,   NumAdult INT NOT NULL,   NumChild INT NOT NULL,   CustomerID INT NOT NULL,   StaffID INT NOT NULL,   CompanyID INT NOT NULL,   PRIMARY KEY (TravelID),   INDEX fk_TravelBooking_Customer1_idx (CustomerID ASC),   INDEX fk_TravelBooking_Staff1_idx (StaffID ASC),   INDEX fk_TravelBooking_Co
OR

MyAssignmenthelp.com has been recognized as the safest dissertation help company in Australia. We conduct a rigorous interview process to select most experienced and talented dissertation experts. This is how, we fulfill students search can someone do my dissertation perfectly or who can write my dissertation plagiarism free and provide them needed academic assistance. Apart from writing help. we also provide dissertation editing services to help students submit perfectly written dissertation.

Most Downloaded Sample Of Database

Data Warehouse In A Simple Language By Dirk Herreman

Download : 1 | Pages : 7

Question: Give a review on Data warehouse in a simple language by Dirk Herreman.   Answer: Data warehouse is a vital source for converting the data into the information form which further can be used for making intelligent decisions (Herreman, 2016). He provides a strong base for the various techniques of data analysis. It is a useful source for accessing the information in a quick and easy manner. The success of any business depends o...

Read More arrow Tags: Australia Flint Management Chemistry Melbourne Institute of Business and Technology Masters in Business Administration 

Applied Databases (Fall 2016)

Download : 2 | Page : 1

Question:

Discuss about the Applied Databases (Fall 2016).
 

Answer:

Identified relations

ER diagram of Dane County Airport

ER diagram of Dane County Airport

ER diagram of Dane County Airport
 

Figure 1: ER diagram of Dane County Airport

(Source: Created by author)

 

Bibliography

Ashford, N., Coutu, P. and Beasley, J., 2013. Airport operations.

Coronel, C. and Morris, S., 2016. Database systems: design, implementation, & management. Cengage Learning.

Read More arrow Tags: United States Miami Humanities Management University of Sydney University of Florida 

Logical Data Model: Database

Download : 0 | Pages : 2

Question: Describe about the Logical Data Model for Database.   Answer: Logical data model   Data dictionary Name PatientID Firstname Lastname Address Contact number CVisitID DOB synonym Patient serial number Patient name Patient Surname The location of patient  Phone number Serial number  data of birth Definition seri...

Read More arrow Tags: United States Lake Forest Computer Science Data Model Assignment University of Los Angeles Computer Science-UC78 

Acme Garage

Download : 2 | Pages : 9

Question: Analyze the current structure of the system used by Acme Garage to maintain the stock, purchase, vendor and transaction details and provide the updated structure with new proposed solution.     Answer: Introduction The purpose of this report is to analyze the current structure of the system used by Acme Garage to maintain the stock, purchase, vendor and transaction details and provide the updated structure with new...

Read More arrow Tags: Australia Melbourne Engineering c# programm Melbourne Institute of Business and Technology PM102 Introduction to Computing 

Business Entity Relationship

Download : 0 | Pages : 5

Question: Discuss about the Essay for Business Entity Relationship.   Answer: Entity Relationship Diagram (ERD) Figure: ER Diagram “ChenOne” fashion stores (Source: Created by Author) How Prototyping can be used in Requirements Engineering? Making software is a very critical task which is carried out by performing several methodologies over the entire development. In the process of software development, the first proc...

Read More arrow Tags: Pakistan Islamabad Management Diversity Sovial Justice and Equity University of Islamabad Masters in Business Administration 
Next
Free plagiarism check online Free plagiarism check online on mobile
Have any Query?