Consider the following relational database schema used to keep track of Ship cruise details and passenger reservation details: Ships (Ship_ID, Ship_Name, Manufacturer) Cruises (Cruise_ID, Ship_ID, Start_date, End_date ) Rooms (Room_ID, Cruise_ID, Room_Name, Type) Passenger_Reservation(Reservation_ID,Cruise_ID,Passenger_ID, Room_ID) Passenger (Passenger_ID, SSN, Name, Phone, Address, Gender) Ports (Port_Name, Port_ID, Port_City) Cruise_stay_at_Ports(Cruise_ID, Port_ID) a) Identify domain for each column. b) Identify the primary key and candidate keys in each table. c) Identify the foreign keys and referential integrity constraints. d) Give two example of key, entity integrity, and referential integrity constraints?

Question  A city college would like to maintain their academic information in a MySql database system.  The following are the interested information: Courses: Catalog # (M170 for instance) Credit Hours; Name of the Course (Database Design Fundamentals for instance) Course Descriptions Prerequisite Components (Lecture, or Laboratory for instance) Classes: Class # Class Name (usually the course name, M 170 for instance) Start Date End Date Meeting time (9:30 am ~ 12:15 pm, for instance) Days in a week (Monday) Term (Spring 2018, for instance) Location (TIE Building for instance) Room (UB 301, for instance) Instructor Online status (online, or in-person) Faculty: Employee Id (001880301, for instance) First Name Last Name Title (professor, for instance) Email Phone Office Location (TIE building, for instance) Room (UB303, for instance) Student: Student ID First Name Last Name Plan Sub Plan Advisor Current GPA Grade of each course The Term you got the grade for a course. The class…

How does a database trigger function, and in what scenarios is it typically utilized?