CSC 240: The Week beginning Dec. 7
Homework:
Finish project.
Make a view for one of your queries.
Insert data into your tables. You should have (on average) at least four records per table.
Export a SQL script for your entire database (when it is done).
Export your tables in various formats: JSON, CSV, XML, and PDF
Prepare a Word document with the Designer View of your database, your statements about your relationships, and the SQL for your queries.
Submit the above Word document and the exported files.
Creating a MySQL View
Due: Dec. 11
Monday:
Finish the security lecture.
Finish the ROBOCOR queries.
Not done yet.
Wednesday:
Work on projects.
Ask questions (get ready for final which is Monday at 8:00 AM).
Friday:
Work on projects.
Ask questions (get ready for final which is Monday at 8:00 AM).