The Assignment You must design a database for booking flights. The following information is given to you about the requirements for the database: 1. Information about all flights. This information should include ID, flightnumber, place of departure, place of arrival, date and time. 2. Information about the person flying. This information should include of ID, name, address, date of birth, email, frequent flyer card number and telephone number. The ID is naturally unique (the same goes for other IDs, perhaps auto increment might be useful?) 3. Information about the booking. This information should include an ID, plane ticket number, date of purchase, price at purchase and status of the payment. Keep in mind that a child cannot travel alone, meaning that one plane ticket number can apply for both children and parents. 4. Information about the flight crew. This information should include ID, name, telephone number, title, certificate number and role on this specific flight. Please take into account that various types of crew members can be assigned to the flight. 5. For each flight, a plane must be allocated and a back-up airplane needs to be decided on. This information should include ID, registration number of the plane, ne of the airplane, make-year and numbers of passengers allowed on board. Draw an entity-relationship diagram with the entities, relationships, attributes cardinalities and keys. Show mandatory participation using double lines and remember to decide if it is 1:1, 1:M or M:M relationship. Also, remember that it might be good to use ISA for some things. Then create the corresponding tables. Keep in mind that we are not building an actual database (then we would not mix the crew and the flyers) so this requirement might be lacking some information that we would otherwise store, if this was a real case however, this description is merely fictional. Deliverables Submit the following two files: a) A wordfile (or PDF) where you have taken a picture of your hand-drawn ER- diagram that you have drawn for the database and in that same document you have also pasted the corresponding tables (you can make them in excel or similar) and hand in everything in one document. b) Also, this should not take up too much of your time as this dmatmaverkefni only gives you 1% of the grade so if you are only able to finish the ER-diagram and not the tables in your dmatmi then you will get 1 point for that as well. The point of this exercise is to get going with the ER- notation. If you also practice by making the tables, then you are better prepared for group project 1 so I recommend that if you have time. The Assignment You must design a database for booking flights. The following information is given to you about the requirements for the database: 1. Information about all flights. This information should include ID, flightnumber, place of departure, place of arrival, date and time. 2. Information about the person flying. This information should include of ID, name, address, date of birth, email, frequent flyer card number and telephone number. The ID is naturally unique (the same goes for other IDs, perhaps auto increment might be useful?) 3. Information about the booking. This information should include an ID, plane ticket number, date of purchase, price at purchase and status of the payment. Keep in mind that a child cannot travel alone, meaning that one plane ticket number can apply for both children and parents. 4. Information about the flight crew. This information should include ID, name, telephone number, title, certificate number and role on this specific flight. Please take into account that various types of crew members can be assigned to the flight. 5. For each flight, a plane must be allocated and a back-up airplane needs to be decided on. This information should include ID, registration number of the plane, ne of the airplane, make-year and numbers of passengers allowed on board. Draw an entity-relationship diagram with the entities, relationships, attributes cardinalities and keys. Show mandatory participation using double lines and remember to decide if it is 1:1, 1:M or M:M relationship. Also, remember that it might be good to use ISA for some things. Then create the corresponding tables. Keep in mind that we are not building an actual database (then we would not mix the crew and the flyers) so this requirement might be lacking some information that we would otherwise store, if this was a real case however, this description is merely fictional. Deliverables Submit the following two files: a) A wordfile (or PDF) where you have taken a picture of your hand-drawn ER- diagram that you have drawn for the database and in that same document you have also pasted the corresponding tables (you can make them in excel or similar) and hand in everything in one document. b) Also, this should not take up too much of your time as this dmatmaverkefni only gives you 1% of the grade so if you are only able to finish the ER-diagram and not the tables in your dmatmi then you will get 1 point for that as well. The point of this exercise is to get going with the ER- notation. If you also practice by making the tables, then you are better prepared for group project 1 so I recommend that if you have time
