given the sample records in the charter table shown in

Project Description:

given the sample records in the charter table shown in table p6.11, do the following:a. write the relational schema and draw the dependency diagram for the table structure. make sure that you label all dependencies. char_pax indicates the number of passengers carried. the char_miles entry is based on round-trip miles, including pickup points. (hint: look at the data values to determine the nature of the relationships. for example, note that employee melton has flown two charter trips as pilot and one trip as copilot.)b. decompose the dependency diagram you drew to solve problem 11a to create table structures that are in 3nf and write the relational schema.c. draw the crow's foot erd to reflect the properly decomposed dependency diagrams you created in problem 11b. make sure that the erd yields a database that can track all of the data shown in problem all entities, relationships, connectivities, optionalities, and cardinalities.
Skills Required:
Project Stats:

Price Type: Negotiable

Total Proposals: 8
1 Current viewersl
64 Total views
Project posted by:


Proposals Reputation Price offered
  • 4.5
    355 Jobs 236 Reviews
    $0 in 0 Day
  • 4.9
    7 Jobs 7 Reviews
    $0 in 0 Day
  • 4.5
    11 Jobs 8 Reviews
    $0 in 0 Day
  • 4.6
    31 Jobs 20 Reviews
    $0 in 0 Day
  • 2.5
    8 Jobs 6 Reviews
    $0 in 0 Day
  • 4.7
    74 Jobs 28 Reviews
    $70 in 0 Day