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
" Excellent work as usual "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1820 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