Assignment 1 - Getting Started
Objectives
Demonstrate ability to get SQL Server operational and create a database within SQL Server.
Assignment
You will be given a data dictionary (below) for a simple database. You will need to install SQL Server, and use SQL Server Management Studio to create a database from the supplied data dictionary. Once you have created the database - you will create a diagram (using SQL Server Management studio) of your database and do a screen capture of SQL Server with the database diagram on the screen.
You will past this screen capture into Word and submit the Word document (you may also submit as a PDF file).
Information
This assignment covers all the basics of getting started with SQL Server, creating a database, and the basic database objects (tables, keys, etc...).
The database you will create will be an extension of the simple music database that was presented in ..
There are lots of music databases out there - for a list see http://en.wikipedia.org/wiki/List_of_online_music_databases. Here is a summary of what your database should include;
|
Information about Artists - This information should include the name of the artist. An artist can be a band or a person who records music with a group of musicians.
Musical Release - Artists typically release music in album or single format. Formats have gotten more complex with the ability to release singles in digital format. Any musical release will have a specific data of release and the artist that released the music. An album is an example of a musical release.
Musicians - Musicians can play for multiple artists (bands or solo artists), or on specific songs. Musicians are identified by their names and the instruments that they play - they can play multiple instruments on a single song.
Songs - Songs are specific releases of a song. A song can be a single release or part of an album release (you need to keep track of this). Songs are recorded by an artist, and have multiple musicians working on them.
|
You will need to input data from an artist of your choice into your database. I highly recommend you discuss the design of your database on the bulletin board - there is no "correct" or "incorrect" design - you want to incorporate as many of the good design principles from your previous database courses in this design.
Estimated Completion Time
This is a review assignment. This should take experienced users 3-6 hours, for less experienced database users you should allot up to 10-20 hours.
Supporting Lectures
Topic - Review of Database I
Questions and Answers
External Resources
Grading Criteria
Grading criteria
Comments (0)
You don't have permission to comment on this page.