Consider this relational model and the following questions in terms of writing SQL DDL code. Change
Fantastic news! We've Found the answer you've been seeking!
Question:
Consider this relational model and the following questions in terms of writing SQL DDL code.
- Change S_MNAME in STUDENN table from mandatory to optional attribute.
- make a constraint for enforcing the business rule that SKILL_ID in SKILL table has minimum 3 digits.
- Add an attribute, DOB (Date of Birth) in STUDENT table
- Add default value as 0 (zero) for HOURLY_RATE attribute of CLIENT_STUDENT table.
- If we increase the maximum size of CID attribute in CLIENT table from four to six, what other changes we need to do, and why?
Related Book For
Essentials Of Statistics For Business And Economics
ISBN: 9781305081598
7th Edition
Authors: David Anderson, Thomas Williams, Dennis Sweeney, Jeffrey Cam
Posted Date: