Need help with this database assignment: I have these tables... Person: Firstnam
ID: 3527550 • Letter: N
Question
Need help with this database assignment: I have these tables... Person: Firstname(Varchar), Lastname(Varchar), StudentID(int), EmploymentID(int) Tutor: EmploymentID(int), TaskID(int) Task: Number(int), Name(Varchar), Responsible_employee(int) Working_on: TaskID(int), StudentID(int) Which primary keys are the different tables going to have? Which limitations could be set/defined to the attribute values for these tables? What would happen if set in a tuplet (5, 236411) in the Working_on table and what limitations would it break? If i change EmploymentID for employee number 8 to 5008, what limitations would that break? Thanks!Explanation / Answer
StudentID and EmploymentID will be primary key for person becos its unique for every student. for Tutor - EmploymentID for Task- Number for Working_on- StudentId StudentID , EmploymentID ,Number should not repeat for different person. and StudentID , EmploymentID shuld be unique (5, 236411) should set TaskID =5 and StudentID=236411 but here StudentID is int but this no is not in range of int so it will neglect the last digit so StudentID=23641 its breaking the limitations of defined range of integer. EmploymentID can't be changed becos its unque