Student Office Visit DB

Using SQL (keyword: create table) to create 3 tables with the column names the same as the powerpoint slide I showed in class (see File, HW2 SQL tab for details).

For PC users, you should go to SQL view, and type the SQL DDL keywords you learned in class to create 3 tables:

Student_table, Email_table, and Office_Visit tables

Each time when you are done with one table, save that query. For example, if you completed creating table called student table, save the query as "Step 1 create table student query"

Once you are done with creating 3 tables, you should have 3 queries already saved.

After you have saved all the three steps, then click File, Save As, then make sure you click another button said "SAVE AS", NOT Save Object AS, then save it to the desktop with section number along with your name and HW2.

Access Homework: create the following 3 tables with the column names and sizes defined using create table SQL

Email Table

Student Table

Office_Visit Table

Note:

• Table and Column names can't have space inbetween.
• Change the column name Date on Email_Table to Email_Date, change Date on Office_Visit to Visit_Date
• You need to create 3 queries, save query to names such as "create student table query, create email table query, and create office visit query"