M3b Create and Use Database – Part 2

Custom Essay Writers for Hire

Submit the statements for the Create and Use Database based on the diagram (as corrected) from the M2b Ivey School of Business: Doctoral Tracking Database – Part 2 assignment.

Please review the complete Create and Use Database Instructions page before submitting this assignment. 

Submit the entire script for the Ivey Database Model as a single text file. The file must include scripts to:

  1. a header, subheaders, and all necessary comments
  2. drop the tables you are creating (in case they’ve already been created within the schema I’m using)
  3. create the tables for the project
  4. insert sample data into the tables
  5. produce the reports listed below

Reports

Click here for best essay writing help.

Course enrollment report for selected term

  • Fields: course number/name, professor (last name comma first name), student (last name comma first name)
  • Sort: course number
  • Input: term (prompt should indicate format for term input)

Course completion status report:  List of all courses a student has started and the status

  • Fields: student last name, student first name, course number, course name, status
  • Sort: Student last name, course number
  • Input: none

Thesis committee report

  • Fields: student name (as last comma first), thesis advisor name (as last comma first), committee member name (as last comma first), chair indicator (a yes/no indication of whether that committee member is the chair)
  • Sort: student last name, committee member last name
  • Input: none

Course sequence: List of all courses and their prerequisite

  • Fields: course number, course name, course prerequisite number, course prerequisite name
  • Sort: course number
  • Input: none

Please review the complete Create and Use Database Instructions page before submitting this assignment. 

 

M3b Create and Use Database – Part 2

Submit the statements for the Create and Use Database based on the diagram (as corrected) from the M2b Ivey School of Business: Doctoral Tracking Database – Part 2 assignment.

Please review the complete Create and Use Database Instructions page before submitting this assignment. 

Submit the entire script for the Ivey Database Model as a single text file. The file must include scripts to:

  1. a header, subheaders, and all necessary comments
  2. drop the tables you are creating (in case they’ve already been created within the schema I’m using)
  3. create the tables for the project
  4. insert sample data into the tables
  5. produce the reports listed below

Reports

Click here for best essay writing help.

Course enrollment report for selected term

  • Fields: course number/name, professor (last name comma first name), student (last name comma first name)
  • Sort: course number
  • Input: term (prompt should indicate format for term input)

Course completion status report:  List of all courses a student has started and the status

  • Fields: student last name, student first name, course number, course name, status
  • Sort: Student last name, course number
  • Input: none

Thesis committee report

  • Fields: student name (as last comma first), thesis advisor name (as last comma first), committee member name (as last comma first), chair indicator (a yes/no indication of whether that committee member is the chair)
  • Sort: student last name, committee member last name
  • Input: none

Course sequence: List of all courses and their prerequisite

  • Fields: course number, course name, course prerequisite number, course prerequisite name
  • Sort: course number
  • Input: none

Please review the complete Create and Use Database Instructions page before submitting this assignment. 

 

Custom Essay Writers for Hire

Share if you Care!

Leave a Reply

Your email address will not be published. Required fields are marked *