This assignment is designed to make sure your software is installed and working properly.

Using MySQL WorkBench complete the following:

A$.$ Install SQL Server Express as described in Appendix A and B starting on page $595$ or using the

instructions located in Course Material $->$ Content $->$ Getting Started.

Install the AP and Harmony$\_$Corp databases as described in the HOW TO Create the

Databases for IST $272.$pdf file in the content area of the course

B$.$ Once the software is installed log in to SQL Server Management Studio, then click the New Query

Button

C$.$ Use the following SQL CREATE command to create a new database called STUDENT.

CREATE DATABASE STUDENT

Then click the Execute Button or press F$5$ to run the command

D$.$ Once you have created the database, type in Use Student to select the STUDENT Table.

E$.$ Use the SQL CREATE command to create a table called FIRST$\_$TABLE with the following fields and

constraints:

Field name datatype comment

STU$\_$ID NUMERIC$(7)$ TTC student ID number, primary key

STU$\_$LNAME varchar$(15)$ last name

STU$\_$FNAME varchar$(10)$ first name

STU$\_$ADDR varchar$(25)$ street address

STU$\_$CITY varchar$(15)$ city

STU$\_$STATE varchar$(2)$ state $2$ letter code

STU$\_$ZIP varchar$(5)5-$digit zip code STU$\_$DOB date date of birth

F$.$ INSERT a record into this new table with your own information as the data. Also, remember that all

varchar data must be surrounded in single quotes $($not double quotes, that is Access!$)$ and numbers do

not use quotes, commas, etc. Only a decimal point may be used if the type of number calls for it$.$ Thus,

to enter your record into the newly created table you would use the following command: INSERT

INTO FIRST$\_$TABLE values

$(1234567,$ 'Smith', 'John', $\text{'}1234$ Anywhere Lane', 'Columbia', $\text{'}$SC$\text{'},\text{'}29123\text{'},\text{'}15-$JUN$-1980\text{'})$ Note:

do not just copy this; use notepad or type it directly into your system.

G$.$ Use the SELECT command to make sure the record was inserted. This assignment is due as posted on

the Course Outline. Submit your CREATE, INSERT, AND SELECT SQL statements following the

format in the $$How to format your chapter submissions$$ document. $($found in the content area$)$ Your

instructor will then check your work in MySQL and give you a grade