Assignment Problem: Consider the information that your school tracks for a class. In this instance, a class is a scheduled course. For example, your school may have BUS 210-Introduction to E-Business as a course. If the school offers it in the fall, then it becomes a class.
Below, we've provided many pieces of information that your school probably tracks about the class.
Complete the table:
Fill out the table by answering the next few questions.
First, what are the field names of the database? (i.e.: class id, days, times, instructor etc)
Second, which is the primary key (place an X in the second column)? Remember that a primary key is field that cannot be duplicated. Also, a database only has one primary key.
Third, the data type for each piece of information or field.
Finally, in the fourth column for each piece of information or field, write down any integrity constraints you can think of. For example, can it be blank or must it contain something? Can it be duplicated across multiple records (classes)? If it's a number, does it have a specific range in which it must fall?