Crow's Foot ERD

The FlyRight Aircraft Maintenance (FRAM) division of the FlyRight Company (FRC) performs all maintenance for FRC’s aircraft. Produce a data model segment that reflects the following business rules: All mechanics are FRC employees. Not all employees are mechanics. Some mechanics are specialized in engine (EN) maintenance. ...continues

Create a query to produce the output shown in the figure below.

Create a query to produce the output shown in the figure below. The output, derived from the CHARTER and MODEL tables, is limited to February 6, 2004. (Hint: The JOIN passes through another table. Note that the “connection” between CHARTER and MODEL requires the existence of AIRCRAFT, because the CHARTER table does not contain a ...continues

Modify the attached query to include data from the CUSTOMER table.

Modify the attached query to include data from the CUSTOMER table. This time, the output is limited to charter records generated since February 9, 2004. The query results are on the attachment.

Create a query to produce the output

Please see the attachment. Modify the query in Problem 2 above to produce the output shown in the figure below. The date limitation in Problem 2 applies to this problem, too. Note that this query includes data from the CREW and EMPLOYEE tables. Note: You may wonder why the date restriction seems to generate more records than ...continues

Database Design - one-to-one relationships - design methodology

Describe the different ways of implementing one-to-one relationships. Assume you are maintaining information on offices (office numbers, buildings, and phone numbers) and faculty (numbers and names). No office house more than one faculty member; no faculty member is assigned more than one office. Illustrate the ways of implement ...continues

SQL - Fuel per hour

see attachment Modify the query in Problem 1 above to include the computed (derived) attribute “fuel per hour.” (Hint: It is possible to use SQL to produce computed “attributes” that are not stored in any table. For example, the following SQL query is perfectly acceptable: SELECT CHAR_DISTANCE, CHAR_FUEL_GALLONS/CHAR_DISTAN ...continues

ERD

See attachment for details. example: http://webfuse.cqu.edu.au/Courses/2006/T2/COIS20025/Assessment/Item_2/Part_A_Resources/erd.pdf

Database Design - relationships - design methodology

Ray Henry needs you to help with database design activities. 1. Ray wants to start a DVD rental program at his stores that he plans to call Henry's DVD Club. He refers to each of his customers as "members." Each member in the club is assigned a number. He also stores the members' names and addresses. In addition, he stores th ...continues

Demonstrate how to insert data into a table

Demonstrate how to insert data into a table: Please provide some sample SQL code.

Advanced Filtering range criteria

I am having a problem with criteria range. I do not know how to set two different criterias in one column. I need to ADVANCE FILTER all of the Clerks (1 and 2) and the Sect. 1 workers who make more than $5.50/hr. I do not understand how to set the title criteria for more than one title. It HAS to be advanced filtered, not auto-f ...continues