| Server IP : 134.29.175.74 / Your IP : 216.73.216.160 Web Server : nginx/1.10.2 System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586 User : Administrator ( 0) PHP Version : 7.1.0 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/nginx/html/JimMartinson/Classes/CST1600/Labs/ |
Upload File : |
Lab09: Create a database Model: -7 Missing the Model. -2 You left the mydb database in your model. EER diagram: -5 Step 3; The model does not contain an EER diagram. -7 Step 3; This is not a Workbench model file. It is a png image with the .mwb extension. .sql file: -8 Step 5; Missing sql script file. See steps 4 and 5. -8 Step 5; This is not a script file created by a Server/Data Export. It does not create the database with sample data. -3 Step 5; I could not create a database from your sql script. Three data rows: -5 Step 5; You did not enter data into your tables. See step 4. -1 Step 5; Not all Three data rows data was entered into the tables. student table -1 Incorrect data type. -4 Data loss. The student phone number are not recorded. I will grade what is here. The student and majors tables are correct. The studentmajors has an incorrect FK to the mydb database instead of yours. -1 Incorrect foreign key. The studentphone has an incorrect FK to the mydb database instead of yours. -1 Incorrect foreign key. -3 No data was entered into the tables.