Sql queries Your documentation should include: 1. A title page clearly stating your name and student ID and your tutor’s name. 2. A copy of the relational schema you have developed from the ER diagram...

Sql queries Your documentation should include: 1. A title page clearly stating your name and student ID and your tutor’s name. 2. A copy of the relational schema you have developed from the ER diagram provided. 3. A copy of the three files you are required to create included in the document (iennnnnnnn_create.sql, nnnnnnnn_insert.sql and nnnnnnnn_query.sql). 4. Full APA referencing of any resources you have used to complete your submission 1. The documentation file described above EITHER as a MS word file or a PDF. If you are using a mac,  submit in a PDF so I can be sure of opening it. 2. The nnnnnnnn_create.sql file (where nnnnnnnn is your student number). 3. The nnnnnnnn_insert.sql file (where nnnnnnnn is your student number). 4. The nnnnnnnn_query.sql file (where nnnnnnnn is your student number). rest see the marking criteria plz aLearning Outcomes Assessed
The following course learning outcomes are assessed by completing this assessment:
•    A1.design and implement a relational database using a database management system
•    A2.utilise a query language tools and techniques to obtain data and information from a database
•    K5. describe relational algebra and its relationship to Structured Query Language (SQL)
•    S1.interpret entity-relationship diagrams to implement a relational database
•    S2.demonstrate skills in designing and building a database application using a commercially available database management system development tool
•    S3.use a query language for data manipulation
Assessment Details
FHTS Incorporated has provided you with a standard solution for the conceptual data model (the ER diagram).  You have been commissioned to continue your role (in your capacity as a Database Management System consultant) and to write the SQL statements to create the database and its tables, add data, and to provide SQL solutions to some of their everyday queries.  The database should be created based on the ER diagram provided at the end of this document.  Some sample data are also provided to be used for inserting data into tables.  However, you are also required to insert sufficient data to test the reports given below.

To implement the database
1.    Translate the ER diagram provided into a relational schema using the correct notations and standards for this course.  It should include:
a.    Table names