An SQL script file containing appropriate SQL DDL (e.g., CREATE TABLE, ALTER TABLE, etc.) statements for creating all the relations from Part 1 (A). 16 marks
The output from running the script file in a live Oracle 11g/12c session (e.g., using SPOOL, copy and paste, screenshots, etc.). 4 marks
You should use relational features from the SQL92 standard in Oracle 11g/12c for constructing your data structures / tables, including appropriate primary and foreign keys.
You should aim for a high degree of reliability in the data with use of as many constraints as possible, e.g., check constraints on various columns (e.g., particular format of primary key values, positive physical values as described in week 4 lecture slides on integrity constraints).
We Write Essays for Students
Tell us about your assignment and we will find the best writer for your paper
Get Help Now!The post An SQL script file containing appropriate SQL DDL (e.g., CREATE TABLE, ALTER TABLE, etc.) statements for creating all the relations from Part 1 (A). 16 marks appeared first on Versed Writers.
Welcome to originalessaywriters.com, our friendly and experienced essay writers are available 24/7 to complete all your assignments. We offer high-quality academic essays written from scratch to guarantee top grades to all students. All our papers are 100% plagiarism-free and come with a plagiarism report, upon request
Tell Us “Write My Essay for Me” and Relax! You will get an original essay well before your submission deadline.
