Create a table called instructors. The purpose of this table is to house the following information: An
Fantastic news! We've Found the answer you've been seeking!
Question:
Create a table called instructors. The purpose of this table is to house the following information:
- An employee id column that is a number - this will be the primary key and it can't be left empty.
- A column with will store an F for full time or P for part time.
- A first name column that can hold up to 25 characters and can not be left empty
- A last name column that can hold up to 30 characters and can not be left empty
- An address column that can hold up to 10 characters and can not be left empty
- A salary column that stores salaries. Our top employee makes $125,000 a year. We want to make sure that if no values are presented, then the default salary of $45,000 a year is entered.
- A marital status column with a fixed length of 1 - we will store the values Y or N
- A column to represent the course that they prefer to teach - for example MAD103, WEB110, etc. Note that all course start with three letters and end with three numbers
If it is not noted, the column can be empty. Choose the best data type to meet the requirements listed here.
Create the appropriate SQL Statement that would build this table.
Related Book For
Data Modeling and Database Design
ISBN: 978-1285085258
2nd edition
Authors: Narayan S. Umanath, Richard W. Scammel
Posted Date: