Question
Student Name: Weight: 2.3% Student ID: Marks: /15 Lab: Creating Tables with Constraints Equipment and Materials For this lab, you will need: A Windows computer
Student Name: Weight: 2.3%
Student ID: Marks: /15
Lab: Creating Tables with Constraints
Equipment and Materials
For this lab, you will need:
A Windows computer with a minimum of 16GB RAM and 250GB of free disk space, capable of nested virtualization
Access to Oracle Version 11g or better through SQL*PLUS
The file Detailed Business Rules for Really Cheap Vacations.docx which is located in Course Resources on Brightspace
Instructions
This is a group activity. Continue to work in the same small group.
Review the physical design and estimate the work required to create tables with constraints. Divide the work up among group members.
Based on your physical design, create the tables along with all the constraints. Use a mix of:
CREATE TABLE with column-level constraints
CREATE TABLE with table-level constraints
ALTER TABLE commands
Create all tables with constraints. Use a prefix of rcv_ for all table names to ensure there are no naming conflicts.
Remember to drop the tables in reverse order with the CASCADE CONSTRAINTS option
Create tables in order (parents first and then their children)
Composite Primary Keys should be implemented as table level constraints (after column definitions)
See Brightspace for exact due date.
Compare your groups completed work against the marking criteria.
Only one submission is required per group. You are expected to submit:
One script file
One spool file (with set echo on) that will drop all tables and will create all the tables with their appropriate constraints
One attribution list that outlines the activities associated with completing this assignment. A sample attribution list is provided on Brightspace.
Marking Criteria
Categories | Needs Improvement (040)% | Adequate (5070)% | Good (80100)% | Score |
Script includes tables from physical model | 4 or more are missing | 1-3 are missing | All | /5 |
Tables created without errors | 2 or more errors | 1 error | No errors | /2 |
Tables created using column level constraints | 0 tables | 1 table | 2 or more | /1 |
Tables created using table level constraints | 0 tables | 1 table | 2 or more | /1 |
Column datatypes are appropriate for data that needs to be stored | 4 or more are incorrect | 1-3 are incorrect | 0 are incorrect | /2 |
Constraints created using Alter Table command | 0 tables | 1 table | 2 or more | /1 |
Constraints from the physical model are correctly implemented | Less than 40% | 40-60% | All | /3 |
Total | /15 |
Can someone do it rather than explaining it, thanks
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started