Database design and optimisation

January 10, 2020

Written Assignment 1

Attached file: LoadDB.sqlPreview the document Download the script file, LoadDB.sql to C:CIS4210Run sqlplus SYSTEM/Oracle11Enter START C:CIS4210LoadDB.sqlEnter SPOOL C:CIS4210M1spool.txtDESCRIBE iggy.part;SELECT * FROM iggy.part;DESCRIBE iggy.supplier;SELECT * FROM iggy.supplier;DESCRIBE […]
January 9, 2020

Web Publishing and Databases

This assignment is about ER/EER Modelling, relational databases, MySQL, linking data using PHPI have attached the brief which includes all the required tasks, as well as […]