Homework Assignment 3: E-R Modeling
Details
This homework assignment evaluates your skills in designing database schemas and drawing ER diagrams. Click on the link below to download the template file that you will use for this assignment. Notice that for this assignment, you will submit two files: your modified sql file plus one diagrams in PDF format.
APAN5310_HW3_UNI.sql (https://courseworks2.columbia.edu/courses/228578/files/24691700?wrap=1)(https://courseworks2.columbia.edu/courses/228578/files/24691700/download?download_frd=1)
Instructions
The attached document is a .sql file. Each question has a corresponding area noted by START and END tags where you will type in your answer. You may use any text editor to type your answers but we recommend that you work within pgAdmin.
When done, save the .sql file and rename it as per the instructions below. You must submit your work before the posted deadline.
Type your SQL statements between the START and END tags for each question. Do not alter this template .sql file in any other way other than adding your answers. Do not delete the START/END tags. The .sql file you submit will be validated before grading and will not be graded if it fails validation due to any alteration of the commented sections.
Our course is using PostgreSQL. We grade your assignments in PostgreSQL. You risk losing points if you prepare your SQL queries for a different database system (MySQL, MS SQL Server, Oracle, etc).
It is highly recommended that you insert additional, appropriate data to test the results of your queries. You do not need to include your sample data in your answers.
Make sure you test each one of your answers in pgAdmin. If a query returns an error it will earn no points.
Important
You may only use and submit the .sql or .txt file that is provided for you in this assignment. No other means of submission will be accepted. Failure to submit the provided .sql or .txt file or properly naming it will automatically result to a zero (0) grade for this assignment.
Submit your .sql or .txt file as the main submission. Only ONE submission attempt is allowed. Then, add your TWO PDF files as separate comments to your submission. Do not attach .sql or .txt files as comments. Date and time of comment submission must also be before the deadline or they will be counted as late (and only two total comments for PDF files are allowed).
Submission
To complete your submission,
1. Click the blue Submit Assignment button at the top of this page.
2. Click the Choose File button, and locate your submission. Make sure you have properly named your sql or txt file so that it matches the format "APAN5310_HW3_UNI.sql" (i.e. for UNI: ab3245 it would be APAN5310_HW3_ab3245.sql). Name your diagram PDF files accordingly and upload those as well.
3. Feel free to include a comment with your submission.
4. Finally, click the blue Submit Assignment button.
Grading Rubric
All SQL queries are evaluated based on the following criteria:
1. Query logic (i.e. use of correct clauses): 30%
2. SQL syntax (i.e. use of correct attributes and predicates): 20%
3. Expected output (i.e. correct and error-free query execution): 50%