Question 10You are a database administrator for a car dealership. The company is growing, and the number of cars the company needs to keep track of has increased. The limitations of the current database design have become more noticeable. There is a lot more repeated data, such as car makes, models, and VIN numbers. This redundancy is causing issues with data integrity and making queries slow. In the tables below what are the primary and foreign keys?

4. Describe the process of creating a foreign key constraint in MySQL, and why is it important in maintaining data integrity across tables.

What is a foreign key of a database?

What is the primary key in a relational database used for?To establish relationships between tablesTo ensure data is stored in binary formatTo uniquely identify records in a tableTo create backup copies of the database

Alexander is developing a ride-sharing application to track drivers, vehicles, and trips. The system needs to handle three main types of data: DRIVERS, VEHICLES, and TRIPS. Write the DDL statements to create the following tables with the mentioned constraints to handle the data: The DRIVERS table has a named primary key constraint pk_driver.The VEHICLES table has a named primary key constraint pk_vehicle for VehicleID and a named foreign key constraint fk_driver for DriverID.The TRIPS table has a named primary key constraint pk_trip for TripID and a named foreign key constraint fk_vehicle for VehicleID.symbol refers to the primary key NN refers to Not NULLAlexander ensures the following constraints are altered:Remove the foreign key constraint named fk_driver from the VEHICLES table.Note: The user must write only the query to create and alter the table. The query to display the description of the table is already given.Input format :No console inputOutput format :The output displays the successful table creation status, the structure of all three tables, and the existing foreign key constraint details.Refer to the sample output.Sample test cases :Input 1 :Output 1 :Table DRIVERS created.Table VEHICLES created.Table TRIPS created.Table VEHICLES altered. Name Null? Type ________________ ___________ ________________ DRIVERID NOT NULL NUMBER NAME NOT NULL VARCHAR2(100) LICENSENUMBER NOT NULL VARCHAR2(20) Name Null? Type ____________ ___________ _______________ VEHICLEID NOT NULL NUMBER DRIVERID NOT NULL NUMBER MAKE NOT NULL VARCHAR2(50) MODEL NOT NULL VARCHAR2(50) Name Null? Type ____________ ___________ _________ TRIPID NOT NULL NUMBER VEHICLEID NOT NULL NUMBER TRIPDATE NOT NULL DATE DISTANCE NOT NULL NUMBER TABLE_NAME FOREIGN_KEY_NAME FOREIGN_KEY_COLUMN REFERENCED_CONSTRAINT_NAME REFERENCED_TABLE_NAME REFERENCED_COLUMN_NAME _____________ ___________________ _____________________ _____________________________ ________________________ _________________________ TRIPS FK_VEHICLE VEHICLEID PK_VEHICLE VEHICLES VEHICLEID 1 row selected. Note :The program will be evaluated only after the “Submit Code” is clicked.Extra spaces and new line characters in the program output will result in the failure of the test case.

Mia is developing a health monitoring app to track user activities and vital signs. The app needs to handle three main types of data: OWNERS, PROPERTIES, and TENANTSWrite the DDL statements to create the following tables with the mentioned constraints to handle the data: The OWNERS table has a named primary key constraint pk_owners for OwnerID.The PROPERTIES table has a named primary key constraint pk_properties for VehicleID and a named foreign key constraint fk_owner that references OwnerID in OWNERS table.The TENANTS table has a named primary key constraint pk_tenants forTenantID.symbol refers to the primary key NN refers to Not NULLWhile creating a table PROPERTIES include a foreign key named fk_owner for the column OwnerID with the references of OWNERS table (OwnerID)After creating the tables, Mia needs to:Add the foreign key fk_property_id to the TENANTS table with the references of the PROPERTIES table(propertyID).Drop the foreign key fk_owner from the PROPERTIES table as it is no longer required.Note: The user must write only the query to create and alter the table. The query to display the description of the table is already given.Input format :No console inputOutput format :The output displays the successful table creation status and the structure of all three tablesRefer to the sample output.Sample test cases :Input 1 :Output 1 :Table OWNERS created.Table PROPERTIES created.Table TENANTS created.Table TENANTS altered.Table PROPERTIES altered. Name Null? Type ______________ ___________ ________________ OWNERID NOT NULL NUMBER NAME VARCHAR2(100) CONTACTINFO VARCHAR2(100) Name Null? Type _____________ ___________ ________________ PROPERTYID NOT NULL NUMBER OWNERID NOT NULL NUMBER ADDRESS VARCHAR2(255) Name Null? Type _____________ ___________ ________________ TENANTID NOT NULL NUMBER PROPERTYID NOT NULL NUMBER TENANTNAME VARCHAR2(100) TABLE_NAME COLUMN_NAME POSITION STATUS _____________ ______________ ___________ __________ OWNERS OWNERID 1 ENABLED 1 row selected.