Hi this is lab 2 assignment of database management just easy 2 tasks I attached all supported documents kindly do this on time and make sure do it perfectly you may need my name and ID for this taskSTUDENT NAME: AHMER NASIRSTUDENT ID: 6880101STUDENT EMAIL:
[email protected]Microsoft Word - laboratory2.docx Diploma of Information Technlology Session: Autumn 2021 UOW College Australia DPIT115 Data Management and Security Laboratory 2 Published on 16 March 2021 Scope This laboratory is related to the conceptual modelling of a sample database domain. The outcomes of the laboratory work are due by Sunday, 28 March 2021, at 11.55 PM. Please read the information listed below very carefully. This laboratory contributes to 5% of the total evaluation in a subject DPIT115. This laboratory work consists of 2 tasks. The submission procedure is explained at the end of the specification. A submission in an incorrect file format, filename format, or as a compressed file (zipped, gzipped, rared, tared, 7-zipped, lhzed, … etc) will not be evaluated. A submission marked by Moodle as Late is treated as a late submission no matter how many seconds it is late. All files left on Moodle in a state "Draft(not submitted)" will not be evaluated. An implementation that does not compile due to one or more syntactical errors scores no marks. It is expected that all tasks included in Laboratory 2 will be solved individually without any cooperation with the other students. If you have any doubts, questions, etc. please consult your lecturer or tutor during lab classes. If it is suspected that you have received assistance from another person to complete the tasks, the matter will be investigated as an alleged breach of the UOW College Academic Integrity and Student Conduct Policy, in accordance with the Procedure for Managing Alleged Student Misconduct. As part of this investigation, you may be required to undergo an oral examination to verify your understanding of the assessment content. Tasks Task 1 (3 marks) Read the following specification of a sample database domain. The following describes a domain of a database for an international chain of hotels. An international chain of hotels would like to create a simple database to store information about its activities. The chain of hotels owns a number of hotels in different countries. A hotel is identified by its address that consists of a country name, city name, street name and building number. The hotels are also described by a unique phone number, unique email address, and a unique link to a web site. All hotels located in the same country and in the same city have unique local names. It may happen that two hotels located in two different cities have the same names. A hotel has a number of employees. An employee is described by an employee number which is unique within a hotel, first and last name, date of birth and position occupied at a hotel. Each employee works at only one hotel. It may happen that two or more employees working in different hotels may have the same employee number. A hotel offers different types of rooms for hotel guests. A room is described by a number unique within a hotel, area, type, and price per night. The customers book the rooms in the hotels. A booking is described by a room type, a planned arrival date, planned departure date, first and last name of a customer, and credit card type and number. A booking is identified by booking date and time. When a booking is cancelled, the cancellation date and cancellation reason are appended to its description and the booking is moved to a class of cancelled bookings. On arrival day a hotel records information about the hotel guests who checked-in. Such information includes the first and last name of each hotel guest, date of birth, nationality, type and number of an identification document and check-in date and time. Then, the hotel guests are assigned to their rooms. Of course, the hotel guests who checked-in a hotel must have a valid booking performed beforehand. On check-out date, a hotel records a bill, i.e. the total amount of money charged for a stay and the services used in a hotel. Your task is to create a conceptual schema of the sample database domain given above and to draw such schema in a notation of UML simplified classes of objects explained to you during the lecture classes in DPIT115. No other notation will be accepted. Use the solution1.docx template provided to show your working. Add your name, student number and date to your diagrams. A sample solution is provided to demonstrate what is expected. To create a conceptual schema, use the methodology explained to you in the presentation 04 Conceptual Modeling. 1. First, read through the specification listed above and find all classes of objects. 2. Next, read through the specification again and find all associations, link attributes, and association classes. 3. Next, read through the specification again and find all attributes and link attributes. 4. Next, read through the specification again and find identifiers and qualifications. 5. Finally, read through the specification and find generalizations. The entire process described above must be included in the outcomes from the implementation of this task. To create the fragments of conceptual schema obtained after each iteration, use the diagram drawing tool UMLet. Remember to use CSIT115-815Palette palette! Technically, to follow the design methodology explained in the presentation 04 Conceptual Modeling you can include the fragments of the database specification listed above into a Word document and then insert into the document the fragments of your diagrams and the final diagram as bmp file obtained from File->Export as … option of UMLet. The structure of the file should include the specification of a sample database domain with the fragments of text with the UML simplified class diagrams representing a solution expanded step by step when you are ready to convert the Word document into pdf format and save it as a file solution1.pdf. If you still do not understand how the problem should be solved, check the sample solution of similar tasks available on Moodle in a file sample-solution.pdf. If you still do not understand how the problem should be solved, then ask your tutor during your tutorial classes. Deliverables A file solution1.pdf with a description of a process of conceptual modelling together with the final design of a conceptual schema. Submission of a file with a different name and/or different extension and/or different type scores no marks. Task 2 (2 marks) Review the lecture material and references tests and form answers to the following questions using your own words, diagrams and examples: (1) Organizations have a vital need for quality information, discuss how the following roles relate to each other: a. Data Administrator b. Database Administrator c. Database Designer d. Application Developer e. End-Users (2) Discuss the three phases of database design and outline the purposes and activities associated with each stage? (3) What are integrity constraints, and how does multiplicity model these constraints? (4) Describe and illustrate, using an example, the process of attribute inheritance (Generalization)? (5) What is the purpose of conceptual database design? How is it utilized while designing a database? You are expected to engage in a discussion regarding these questions during your tutorial in order to gain marks for this task. The file questions2.pdf with your answers to the questions, your name student number and the date, should be included on each page. Submission of a file with a different name and/or different extension and/or different type will score no marks. Submission Note that you have only one submission. So, make it sure that you submit correct files with the correct contents. Submit a files solution1.pdf and questions2.pdf to the Lab Task 2 submission area on the Moodle site. End of specification solution1 Step 1: Create classes of objects The following describes the contents of a database to be designed for an international travel company. An international travel company consists of a number of branches located all over the world. A branch is identified by an address, that consists of a country name, city, street, and building number. The branches are also described by a phone and fax numbers, email address, and local name. An address, phone number, fax number, and email address are unique for all branches. All branches located in the same country have unique local names. A branch has a number of employees. An employee is described by an employee number which is unique within a branch, first and last name, date of birth and position occupied at a branch. An employee works at one branch only. It may happen that two or more employees each working in a different branch have the same employee number. The branches offer the travel opportunities, later on called as "trips" to the customers. A trip is described by a unique name, total price, and short description. A trip consists of a departure location, zero or more of intermediate stops and a destination location.