1. Design the database in an MS Excel spreadsheet as a single relation

called Movie. It should contain an ID, Title, Year Released, Genre (e.g.,

sci-fi, comedy, thriller, etc.), Rating (e.g., G, PG, R, etc.), Format (e.g.,

VHS, DVD, MP3, etc.), a free-form Comments field, plus the main cast

and crew members. Add the following entry plus at least two of your

own: (2 marks)

ID: 1

Title: Star Trek

Year: 2009

Genre: Sci-Fi

Rating: PG

Format: DVD

Director: J.J. Abrams

Starring: Chris Pine (Capt. Kirk), Zachary Quinto

(Mr. Spock) Zoe Saldana (Uhura), Karl Urban

(Bones McCoy)