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