数据库代写｜W4112 Database Systems Implementation Project 1
Given the provided case study from assignment 1A, and additional forms/documents related to the case study, students will be asked to transform the information provided into a sound database design and implement it in Oracle. This task covers learning outcomes:
- Applythe theories of the relational database model;
- Developa sound relational database design;
- Implementa relational database based on a sound database design.
This is an open book, group task (students will work in groups of two or three students with members selected randomly). The final output for this task will be a logical model implemented in the Oracle RDBMS
This task continues the work you have started in assignment 1A by refining/extending the model you developed and implementing it as a set of tables under your Monash Oracle database account. Since this is an ongoing development process based on your assignment 1A submission and marker feedback,you must ensure that your assignment 1A submission and the marker feedback remains confidential and is only seen by the members of your group and the FIT2094 teaching staff.Assignment 1B’s brief must be read in conjunction with the assignment 1A brief – ie. your final model must encompass both sets of requirements. You may modify your assignment 1A conceptual model in any manner you wish as you work through assignment 1B, provided your final model meets both sets of requirements.
In developing your final logical data model, composite attributes present on your conceptual model must be expanded into their component simple attributes,unless otherwise directed. If the supplementary material presented in this document does not guide you in deciding the components you may make any reasonable decision on their simple component attributes.
Further discussions with World Cruises have revealed the points listed below:
a. WorldCruisesrecord for each passenger their contact phone number, for a minor no contact number will be recoded, the contact for their guardian will be used (in modelling this point keep phone number as a simple attribute of passenger, do not create a further PHONE relation)
b. at ports, where acruisestops, local entrepreneurs offer various tours to the passengers which they can participate in while the ship is in port. The tours are not specific to a particular cruise, any ship which is in port can have passengers partake in an advertised tour. Some tours provide audio commentary to help explain what passengers are experiencing. Where possible the tours are encouraged to supply the commentary in a range of languages so as to support the needs of as many passengers as possible. The commentary languages available for a tour must be stored as part of your model.
Tours are offered at regular intervals for example every weekday, every Saturday, on Monday only, etc (this range of offerings may be changed regularly, including adding new ranges). A particular tour only runs once on any given date.Each offering of a particular tour uses the same tour number. Tour numbers are reused for each port ie. each port has a tour number 1.Each tour has a minimum number of participants, a particular tour offering is not run unless this minimum number of participants have booked for it.
c. cabinsacross the various ships are assigned a cabin class as one of the following
○ ocean view
○ balcony, or
These classes are fixed and will not be modified.
d. countrycodesstored in the system make use of the ISO 3166-1 Alpha-2 codes eg. Australia is AU
e. languagesstoredin the system are stored as ISO 639-1 Alpha-2 codes eg. English is EN
f. latitudesand longitudes stored in the system are stored in decimal form, for example the latitude and longitude of Hobart, Tasmania, Australia is:
○ latitude: -42.8825088
○ longitude: 147.3281233