When explaining choices, be sure to attribute any sources you use.
Note about Screen Shots
This learning event will require you to take screen shots demonstrating your ability to use various SQL Server 2000 tools to create databases and database objects. To take a screen shot of the window that is currently in focus, hold down the ALT key and press the 'PRT SCR' button. Then, in your Word document, paste the image using CTRL-V or the Edit->Paste menu item. In addition, to take a screen shot of the entire screen regardless of window focus, hold down the CTRL key and press the 'PRT SCR' button. Then paste the image as described above. If you have any questions or trouble with this method of creating screen shots, contact your instructor. Remember to verify that your screen shots are legible - resize them if necessary.
Individual Learning Event
Start the SQL Server 2000 Enterprise Manager and use the navigation tree structure.
Include a screen shot of the Enterprise Manager with the SQL Server service stopped.
Include a screen shot with the Databases, Management, Replication, and Security folders expanded/open in the navigation tree structure. Have the focus on the Database folder so that all six of the default databases are listed in the right pane of the Enterprise Manager.
Create an SQL Server database on the local server.
Create a database for an organization with which you are familiar. It can be fictional or real. Be prepared to create at least 3 - 4 tables to capture the database needs of the organization. Provide a 2 - 3 paragraph description of the organization and what you perceive its database needs to be.
Keep it simple - your database does not have to completely capture the data needs for the organization. For example, you might choose to create a video store database with a customer table, employee table, movie table, and rental_order table. There are obviously other tables that would be needed to completely capture the data needs for a video store, but these tables provide a good starting point.
Explain the physical and logical design decisions that you made. Justify your choices for the relationships you defined between the tablesas well as your choices for primary and foreign keys, Describe how the data is stored in the tables.
Take screen shots of the steps necessary to create the database with a text explanation of your actions and choices at each step of the database creation process. Be sure to address sizing and space parameters and your reasoning for those choices.
Create tables in the database you created including adding columns (fields) of an appropriate data type to the table and designating a primary key.
Create at least 3 - 4 tables with what you feel are appropriate columns and data types. Also identify the primary key of each table. Remember, you will not be graded on the validity or correctness of the data type or column - use common sense. Provide a 1 - 2 paragraph explanation of your table choices.
As with the database creation process, take screen shots of the table creation process for one of the tables and add an explanation for each steps actions and choices (if any).
Finally take a screen shot of the all the tables you created in your new database. Do this by navigating to your database in the Enterprise Navigator tree and selecting Tables. The tables you created should appear in the pane on the right.
REMEMBER: The focus of this learning event is on the successful creation of the database and tables, not on the appropriateness of your organization and table choices. Your assignment includes screen shots and explanations in a Word document.
Microsoft SQL Server 2000 Problem
Please help with the following problem involving programming languages.
I am using Microsoft SQL Server 2000
1. Using the database and tables in the attached doc, write Microsoft SQL statements and enter ten more records into the employee table. Check the results by selecting all of the columns from both of your tables
2. Using the updated database, write the following queries using the SQL GROUP statement:
A. Group employees by job code: Select the employee's last name and group them by job_title_code.
B. Group employees by salary: Select the employee's last name and group them by salary.