Galaxy is an international Airline company. The company has several Airports eachAirport is located at a different country. Each Airport has a name and capacity.Each Airport can hold several Aircrafts at the same time. Each Aircraft has ID,Type and Capacity. The Company has many Employees working in Airports. EachAirport has many employees working in it. Every employee working in an Airportcan only one of three Jobs: Pilots, Admins and Mechanics. Each Employee has anID, Name and salary. Pilots have Number of Flight hours and Mechanics haveyears of experience. The company keeps information of its customers. Eachcustomer has Name and Passport ID. A customers can book one or more tickets.The company keeps information of its tickets such as flight date, Flight ID andTicket ID. Each Ticket is associated with one customer and Aircraft. Please complete reading page 1 before going to page 2.In task 2, you will be given a text that describes an Airline company (page 2). Eachstudentshould complete the steps 1 and 2 below to fully solve the task.Step 1: Represent the company description as an ER-diagram, including all relevantconstraintsas the following steps:-LucidchartBlank diagramEdit Select View Insert Arrange HelpShapesEach student should download Lucidchart app using MS-Teams. A videoabout downloading Lucidchart has been added to e-learning.Every student should use Lucidchart draw the ERDThe student should take a screenshot of his solution showing his/her user IDas the example below (in Red):For each entity name in the ERD the student should concatenate hisUniversity ID as the example below (in Red)StandardΤΠDOOLiberation Sans Y <-10 pt - BIVAT BAZ2px None NoneMQFlowchartODDEShapes00<<TASK 2: Draw ERD and Map to RelationsTOBOO40X× BODOL0 (What's NewSavedStart a free trial to access unlimited shapes and documents! XDIDNameAfter each entityname include youruniversity ID numberDepartment0190334Dep_IDID408Employee0190334Presentwhen you createprint screen, youruser ID should beshownStep 2: Map the ERD you have created to relations including all keys (PKs and FKs)NameImportant Notes:1. Students should follow the given instructions exactly, otherwise will notbe given the grade2. The solution should be includedin (ONE PDF) File (solve on Wordthen transform to PDF). Please submit one file only to E-Learning(NO emails No MS-TEAMS messages). No submission will be acceptedafter the deadline.

Entity relationship model and Map to Relations:- ER model is a conceptual model by which you can…

Galaxy is an international Airline company. The company has several Airports each Airport is located at a different country. Each Airport has a name and capacity. Each Airport can hold several Aircrafts at the same time. Each Aircraft has ID, Type and Capacity. The Company has many Employees working in Airports. Each Airport has many employees working in it. Every employee working in an Airport can only one of three Jobs: Pilots, Admins and Mechanics. Each Employee has an ID, Name and salary. Pilots have Number of Flight hours and Mechanics have years of experience. The company keeps information of its customers. Each customer has Name and Passport ID. A customers can book one or more tickets. The company keeps information of its tickets such as flight date, Flight ID and Ticket ID. Each Ticket is associated with one customer and Aircraft.

Galaxy is an international Airline company. The company has several Airports each Airport is located at a different country. Each Airport has a name and capacity. Each Airport can hold several Aircrafts at the same time. Each Aircraft has ID, Type and Capacity. The Company has many Employees working in Airports. Each Airport has many employees working in it. Every employee working in an Airport can only one of three Jobs: Pilots, Admins and Mechanics. Each Employee has an ID, Name and salary. Pilots have Number of Flight hours and Mechanics have years of experience. The company keeps information of its customers. Each customer has Name and Passport ID. A customers can book one or more tickets. The company keeps information of its tickets such as flight date, Flight ID and Ticket ID. Each Ticket is associated with one customer and Aircraft.

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

1st Edition

ISBN:9780357392676

Author:FREUND, Steven

Publisher:FREUND, Steven

Chapter3: Working With Large Worksheets, Charting, And What-if Analysis

Section: Chapter Questions

Problem 1.1EYK

See similar textbooks

Similar questions

Make the functions below according to the attached class diagram and GUI program mockup. No The function to be made 1 Create Transaction Order_ID = 1 Order_Date = 11-2-2021 Customer_ID = 2 Customer_RefNo = 001 / I / S / 2021 When the TextField 'txtCustomerID' is filled and we click the 'View' Button, then the TextField 'txtViewCustomerName' will display the 'Customer_Name' field from the Customer's Table according to the input Customer_ID. If the data is not found, a notification will appear “Customer not registered”. 2 Fill in the List Combo Box Product_ID by retrieving data from the Product Fied Table Product_ID 3 If the button ‘Tambah Item’ is clicked, then data from Product_ID, txtProduct_Name, txtQuantity, txtPrice will be saved to the 'Order Detail' Tabke (according to the mockup), then also enter the Sub Total field in the 'Order Detail' table with the calculation of txtQuantity * txtPrice. 4 When the ‘Hapus’ button is clicked, data from…
Assignment Instructions Below, create a table and graph like the ones in the 'Example | Part 1' tab. Follow the steps below to do this. 2.In the 'Table Area' below, create a table with three headings with the following order: Year, Total Money Earned at Current Job, Total Money Earned at Future Job. (See 'Example | Part 1' tab) 3.In the column under year, start with the number 1 and fill the cells down to 20 years. 4.In the column under "Total Money Earned at Current Job" calculate the total amount of money Cindy will have earned by the end of each of the corresponding years. Do this by writing an equation that multiplies the year by 12 and then by the monthly earnings for that job. (See 'Multiplication' on 'Grading Sheet | Help' tab) Be sure to use a relative reference for the year and an absolute reference for the earnings number. (See 'Cell References' on 'Grading Sheet | Help' tab) Copy the equation down the column for all 20 years. 5.Do the same type of equation for the column…
Task 5: ' The Driver Relationship team realized that there is no need for DRIVER_DRIVING_LICENSE_CHECKED field in the active drivers table. Since all the drivers are already active in InstantRide, their driving licenses should be checked regularly. The team wanted you to remove the field from the table. ANSWER IN MYSQL PLEASE
To vary your reporting, you decided to include graphical representation. Create a clustered column chart that shows the total amount each active customer with a data plan must pay. Format the total pay column to currency and give the chart an appropriate title. Remember to label the axes. (Hint: Create a query and export it to a spreadsheet application to create the chart.) Ensure that the chart is labelled appropriately and is placed on a new sheet. Name the Spreadsheet as MGMT2006_G#_<first name last name>. For example, MGMT2006_G50_ Jane Doe.
8. In the following code below, the code selects an Employee object by primary key. However you are missing the line of code to create the employee variable. What line of code are you missing? [HttpGet] public IActionResult Edit(int id) { ViewBag.Action = "Edit"; ViewBag.Departments = context.Departments.OrderBy(d => d.DepartmentName).ToList(); ________________________________________________ return View(employee); } 1. var employee = id 2. var employee ="select * from Employee where Id = id"; 3. var employee = context.Employees.Find(id); 4. context.Employees.Find(id) = employee;
Recreate this diagram please