Question: You are doing a consulting project for an educational institution and want to convince them to utilize your software. From the previous lab, you realized

You are doing a consulting project for an educational institution and want to convince them to utilize your software. From the previous lab, you realized how tedious and time consuming it is to create the records and enter data into your tables. Its even more time consuming if bad data enters the equation, lets prevent that from happening. With this lab, you are to ensure that only GOOD data enters your records by means of constraints. Belowis a listofintegrity and value constraints that need to be added to your current record formats. You should not change your previous lab, this should be appended to the end of lab 1. CSCI 2370 - Database Systems Programming Professor Ryan Kramer Page 2 Check Constraints STUDENT- ZIPonly 0-9 and - onlyvalid characters(US zipcodestandard, ie. 45693, 45693-1234) STUDENT- PIN Any character set ANDNOT NULL STUDENT- MI Valid characters(A-Z)orNULL SECTION- DAYSVALIDVALUES'M''T''W''R''F''S''U'(can storemultiplese.g.MWF) SECTION- STARTTIME MUST BEPRIOR TOENDTIME SECTION- SEATSAVAILABLE <100 COURSE - CREDIT HOURS <= 6.0 STATUS A orI exceptbelow o STUDENTTable Valid values areC, T, 'I'(Current,Transfer, Inactive) o FACULTY Table - Valid values are F, A(Full-time, Adjunct) NOTE: Youmay need to update the current dates Assignment: You may need to modify the data to make the constraints valid. Double check your data if you are having an issue setting the constraint. TURN IN: The alter statements you executed on the tables in order to make the check constraints ensure integrity in your schema. If you are modifying data, please make sure to commit your DML changes.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!