Computer Science 2

{Your Name}

ITCO333 – Unit 2

{date}

Hint: Refer to the Unit 2 - LoCoco – Sample.pdf in the Instructor Files area for an example.

Requirements

· This database must contain examples of one-to-one, one-to-many and many-to-many relationships.

· I will compare your Unit 1 ERD with the Unit 2 database diagram. If there are differences, explain why.

· Present your SQL statements in the order in which they were executed.

· Put your database diagram at the top of your document (see my sample).

· You must provide proof (via a screen shot) that your SQL statement executed.

Relationships (from Unit 1)

Include corrections based on the feedback you received.

Relationship Type	Entity #1	Entity #2	Description / Justification
one-to-one (1:1)
one-to-many (1:M)
one-to-many (1:M)
many-to-many (M:N)

Your Unit 1 ERD

Include corrections based on the feedback you received.

Database Diagram

Refer to: http://www.youtube.com/watch?v=wMbPRHeYvMU

SQL DDL to create database

Create tables, Fields, Primary Keys & Foreign Key

DML to populate the database

Full SQL

Perform TASKS > GENERATE SCRIPTS. Copy and paste the full database script here.

Refer to the “Generate Scripts for Entire Database.pdf” in the Instructor Files area.

Page 5 of 5