Threesuns

Email the Instructor

Contact

All Semesters

Semesters

All Courses

Courses

2010Spring

01.11.10 - 05.09.10

Database Design (Online)

CSYS2643

Online
12:00 AM - 12:00 AM

SQL

Lab08

Objective: To implement your database

pastdue

Submit Your Solution

Lab08

Requirements

All tables are created according to design40 pts
Table fields are created according to design40 pts
All tables include test data20 pts
Total100 pts

Instructions

For this lab you will need to, on your own using whatever resources you prefer, implement your database.

Begin by downloading and installing MySQL on your computer along with the GUI tools which will be needed to access and manipulate your database. There are many resources available on the internet that describe this process.

Once MySQL is setup and it working, use the MySQL Query Browser to execute the mysql statements that are needed to create the tables for your database.

Once your tables are created, use SQL insert statements, update statements, and delete statements to place data in all of your tables and to then manipulate it to ensure that everything in the database is working as you would expect.

Once your database is created and data has been included in your tables, backup your database and submit the backup file as your solution to this lab.