You are interested in compiling a small SQL database of the contents of this course. You decide you want a table that categorizes assignments by the category of credit that each generates, and another that describes the individual assignments and relates them to the categories table. Within the categories table you want to be sure to include the name of the category and the percentage that category contributes to the overall grade. Within the assignments table, you want to be sure to capture the name of the assignment, the category of the assignment, its contribution of points each assignment adds to the category, the due date of the assignment, a flag for whether you have completed the assignment or not, and a field for the points that you received for the assignment.
You are interested in compiling a small SQL
Open a new Excel spreadsheet and create a description of the two tables that you will create in that spreadsheet. This design should look like the standard table view seen in the previous discussion. Be sure to give each of the fields in the database a name and an appropriate data format, include any keys or indices that you think are appropriate, and indicate how the two tables interact with either arrows or words. Beneath these two table descriptions in your Excel spreadsheet, write two sample insert commands to insert this assignment and the previous discussion’s assignment into the table you have designed.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images