Assignment 5 Tour Operator Agency Database

Feb 3rd, 2012
Studypool Tutor
Academy of Computer Education
Price: $15 USD

Tutor description

Design a data model that will conform to the following criteria: Propose an efficient data structure that may hold the tour operator’s data using a normalization process. Describe each step of the process that will enable you to have a 2nd Normal Form data structure. Create naming conventions for each entity and attributes. Conclude your data model design with an Entity Relationship Model (ERM) that will visually represent the relationships between the tables. You may make use of graphical tools in Microsoft Word or Visio, or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length.

Word Count: 583
Showing Page: 1/7
Travel Company Database SystemYour NameYour College/Your UniversityAbstract Information demonstrating is a typical action in the product improvement methodology of data frameworks, which regularly utilize database administration frameworks to store data. The yield of this movement is the information model, which portrays the static data structure regarding information elements and their connections. This structure is frequently spoken to graphically in element relationship charts (ERDs). The improvement of visit administrator office begin with building up a point of interest story of the clients operations, for instance a visit association has businessperson and the salesman need to offer diverse visits to the client in different times. When business guidelines is created than Identify the business standards in view of the portrayal of operations. In these stages numerous meeting and gathering will be led with stakeholder and clients, once the business tenets distinguish that Tour Sold record will be upgraded and the stakeholder can at whatever time survey and changed the Tour Sold archive.An efficient data structure that may hold the tour operator's data using a normalization processBelow is the data model for 2nd Normal form for Travel Company. Their table name and column names are mentioned in the table.SalesPersonsEmployeeIdFirstNameLastNameToursSoldIntegerTextTextIntegerCustomersDataCustomerIDCustomerNameAddressCity StateZipCode

Review from student

Studypool Student
" Solid work, thanks. "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1824 tutors are online

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors