Map the given EER into the relational model. Three are three options for mapping a specialization. Please use the option of "Option1: Create a table for each class (both superclass and subclass)". Please include all the relations and views (if there is any). All assignments' submissions in this course must be typed and submitted electronically through Canvas. You must submit a PDF file. Files in another format will not be accepted. SSN Salary Student Name ΤΑ STUDENT Address N Email Grade Enrolled In Course No. M No_of_Students ONLINE COURSE URL Graded by N Building Room Id. Course Name COURSE N IN PERSON_COURSE N Taught by Takes Place in 1 Room No CLASSROOM 1 Title Instructor ID INSTRUCTOR Capacity Class_time Instructor Name

a) Complete the object conceptual data model for the following relational schema. Branch BranchID Location B001 Shatin ВО02 Homantin Order OrderID SalesTotal BranchID 0001 100 BO01 0002 200 BO02 0003 300 BO01 BranchID is the primary key of Branch table. OrderID is the primary key of Order table. BranchID in Order table is the foreign key references Branch table. Now, assume the OIDS are given below: Branch BranchID Location OID B001 Shatin OID1 B002 Homantin OID2 Order OrderID SalesTotal BranchID OID 0001 100 ВО01 OID3 0002 200 ВО02 OID4 0003 300 ВО01 OID5

PLz help with the following: Translate your ER diagram into a relational schema in the form of SQL DDLs. Choose appropriate data types for each attribute and include primary key and foreign key constraints, Check and Not Null constraints.

In the Testa EV database design described in the previous question, please complete a field specifications form for the field 'Model_Cost' of the table 'Model_T'. The field records the cost of producing a specific EV model. Because its data come from the cost data of specific parts used to build the model, its value can be entered later and editing is allowed (null is allowed). The field value is required. Only decimal numeric data are supported for the entered value. The field can store a maximum of 10 digits (including 2 decimal places). The user of the database (data analyst) is responsible for entering and maintaining the data. No specific range of values is specified for this field. You should enter 'N/A' (or leave it unchecked) for elements that are not applicable.

Answer questions 2.1 to 2.4 based on the following schema. Note that primary keys are in BOLD. Note also that attributes with the same name in different tables are foreign keys. For example, doctorID in the Treatment table is a foreign key that refers to the Doctor table. Doctor(doctorId:integer, specialtyID:integer, firstName:varchar(20), lastName:varchar(20), salary:numeric(11,2)) Specialty(specialtyID:integer, specialtyName:varchar(20), specialtyCost:numeric(11,2)) Treatment(doctorId:integer, patientSSN:integer, dateTreated:date, costOfTreatment:numeric(11,2)) Patient(patientSSN:integer, firstName:varchar(20), lastName:varchar(20), street:varchar(30), city:varchar(15),  state:char(2),zipCode:integer(5)) 2.3) Write an SQL statement to increase the cost of all Specialty treatment by 2.5% 2.4) Write a SQL statement to delete all treatment rows that were done before 2015 and cost less than $500. 2.5) Write an SQL statement to select all Specialties where the specialtytName has a null…