Exercises from the textbook to practice for Exam 1

(exercise numbers differ based on edition) and added similar problems (*):

1. Student(StudentNumber, StudentName, SiblingName, Major)
2. * Student(StudentNumber, StudentName, Major) ? double major
3. Student(StudentNumber, StudentName, SiblingName, Major) ?siblings and double major
4. ORDER_ITEM(Order_Number, SKU, Quantity, Price)
5. * ORDER_ITEM(Order_Number, Barcode, Quantity, Price) ? which price
6. * ORDER_ITEM(Order_Number, SKU, Quantity)
7. Discuss textbook case Projects with tables:

Department (Dep_Name, BudgetCode, OfficeNumber, Department_Phone),

Employee (E_ID, First, Last, Department, )

Project (P_ID, Project_Name, Department, MaxHrs, Start_date, End_Date) Assignment(P_ID,E_ID, hrs_worked)