Creating tablesWhen creating the fields, make sure you select the correct data type and add enough characters per field. Field names do not contain a space.Create a table named course with the following fields; course id (primary key), course num, course nameCreate a table named student with the following fields; student id (primary key), first name, last name, major, phone, semester, year, age.Create a table named professor with the following fields; professor id (primary key), first name, last name, department, hire date (date field).Create a table named semester with the following fields; semester, yearCreate a table named teach with the following fields; teach id (primary key), course id (foreign key, based on course id in course table), professor id (foreign key, based on professor id in professor table), semester, building, class room numberCreate a table named take with the following fields; teach id (primary key, foreign key based on teach id in the teach table), student id (primary key, foreign key based on student if in the student table

Given: Creating tablesWhen creating the fields, make sure you select the correct data type and add…

Answered: Creating tablesWhen creating the…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

Creating tables
When creating the fields, make sure you select the correct data type and add enough characters per field. Field names do not contain a space.

Create a table named course with the following fields; course id (primary key), course num, course name
Create a table named student with the following fields; student id (primary key), first name, last name, major, phone, semester, year, age.
Create a table named professor with the following fields; professor id (primary key), first name, last name, department, hire date (date field).
Create a table named semester with the following fields; semester, year
Create a table named teach with the following fields; teach id (primary key), course id (foreign key, based on course id in course table), professor id (foreign key, based on professor id in professor table), semester, building, class room number
Create a table named take with the following fields; teach id (primary key, foreign key based on teach id in the teach table), student id (primary key, foreign key based on student if in the student table

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 7 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions