Database Assuagement

Assignment #1 CIS3310

A. Establish three (3) Mission statements with supporting mission objectives. (25 pts.)

B. Establish the Table structures of the following based on preliminary field list. (75 pts.)

Video Catalog

Movie title

Movie duration (in # of minutes)

Movie rating (number of stars)

Movie synopsis

Movie actors/cast

Movie production companies

Movie genres

Director

Writer

Year released

Music Catalog

Song title

Album name

Artist/band name

Genre

Song duration (in # of minutes)

Album release date

Album label (company)

Members of band

Song composers

Runner’s Club Membership/Activity Tracker

Runner name

Runner City

Runner phone number

Membership payment amount

Membership payment date

Runner type of membership (lifetime, annual)

Running Event title

Running Event date

Running Event location

Running Event participant names

Task Manager

Task title

Task assigner

Task assignee

Task category

Task due date

Task status/progress

Task status date

Event Management

Event title

Event date

Event location (address, city, state, zip)

Phone number

Email address

Guests First name

Guest Last name

Event Agenda items (start-time, end time, agenda title/description)