Requirements Question 1. Write the SQL query to create the table structures for the entities shown in Figure1 ER-Diagram. The structure should contain the attributes specified in Figure1. Use data types that are appropriate for the data that will need to be stored in each attribute. Enforce primary key and foreign key constraints as indicated by the diagram. Figure1 LGOUSTOMER PK Cast Code LOBRAND PK BreadID LGLINE Cust, Frame Cust, Leame Quat Seet Cus Cay Qusate OUR OP Cust, Balance LORVYOICE PK in Num PK1 Cust Code in Date Total FK2 Employee ID completes LEUPLOYEE EmpFrame Emp_name Empfmal Ewp Phone Emp Hea Emp Tele EmpComm FK1 Dept Num enjoys mankges LGDEPARTMENT PK Dept Num FK1 Emp Num Dept Name Dept Mall Box Dept Phone contains PKPKI PK FKZ Nam Line Num Pror SKU Line Qty Line Price LOSALARY HISTORY PKFK1 Emp Num Sal. From Se End Sal Amount 回主 Brand Name Bread Type inclos LOPRODUCT K Pred Descript Proc Type Proc Base Proc Calgary Pred Price Pred QOH Prod Min FKY Brand 10 provided by LOSUPPLIES PKFKI Veed.ID PKFK2 Prod SKU proudes LGVENDOR PK Yea Ves Nome Vent Street Vent Cly Vend State Vend ZP

6. You have been asked to store five attributes that poses the following analytical data types into a SQL Server relational data store. Identify and explain the data-type that you would select for each respective column when designing a table/relation that will house those five data attributes (assume that the order of the columns in the table will match the order of the data attributes listed below): 1. Interval attribute whose values are presented as textual data 2. Ordinal Attribute whose values are presented as numeric data 3. Ratio Attribute whose values are presented as numeric data 4. Nominal Attribute whose values are presented as textual data      No hand written and fast answer with explanation

SQL Queries:   Given the following schema. Primary keys are underlined and highlighted in yellow and foreign keys are bold. The meaning of the relations is straightforward. Medical_Staff(MS_Id, MS_First, MS_Last, MS_PhoneNumber, MS_Occupation, Salary) Blood_Bank(Bank_Id, Bank_Name, Bank_Street, Bank_City, Bank_St, Bank_PhoneNumber) Donor(Donor_Id, Donor_First, Donor_Last, Donor_BloodType, Donor_City, Donor_St, DOB, TotalNumberOfDonations) Donation_Record(Donor_Id, Donation_Date, Donation_Amount) Employee(MS_Id, Bank_Id) Storage(Donor_Id, Donation_Date, Bank_Id)   Write SQL queries to answer the following questions:   a.Find the average donation amount for Sue Thompson (Donor Id = 3329) for the year 2018.                   b.Sum all donations by Bank for each State (i.e. the State the blood bank is located in, not the Donor).                     c.Find the name of the youngest donor and all the donations made in by that donor in 2020.

Based on the following ER model and business rules, write an SQL statement to create COURSE and COURSE_PREREQ table. Be sure to implement all related data integrity constraint. For each column, use the data type as you think appropriate. Business rule • A course may have more than one prerequisites. The prerequisite courses may have their own prerequisite courses (more than one). COUSE entity • CourseNo is a UID (unique identifier). • Credit hours should be greater than 0 and less than 7. COURSE_PREREQ entity • UID is the composite of CourseNo and CourseNo (i.e., prerequisite courseNo). COURSE COURSE_PREREQ CourseNo: UID Title Description CourseNo: LCourseNo: UID CreditHours

Please find the relational schema and the Sql Statement

Instructions In SQL Server, create a new database called University. Given the ERD in this document, write the CREATE TABLE statements to construct the tables for this database.  Be sure to use reasonable data types and create all tables, attributes, primary keys, foreign keys, and “not null” constraints in your statements where appropriate.  To receive full credit for this assignment, your CREATE TABLE statements must be executed in SQL Server.  In a new Word document, copy the ERD and type your CREATE TABLE statements below the ERD.  Then, in SQL Server, after you execute each CREATE TABLE statement, issue these two statements: SELECT * FROM [table name] exec sp_help [table name].

Complete a database design for both the Invoice_printed and Real Estate Agent Listings problems / cases. Display your normalized tables as as demonstrated in the following format: TABLENAME(Field 1 (pk), Field 2, Field 3........)

Question 1. Write the SQL query to create the table structures for the entities shown in Figure1 ER-Diagram. The structure should contain the attributes specified in Figure1. Use data types that are appropriate for the data that will need to be stored in each attribute. Enforce primary key and foreign key constraints as indicated by the diagram.

Question 3: Create the DDL statements to create the tables described in your modified ER diagram in question 2: DDL Statement: CREATE TABLE School ( school_code integer Primary Key(10), location varchar(25), name varchar(10) ); CREATE TABLE Professors ( staff_id integer(10), name varchar(20), school varchar(30) ); CREATE TABLE Course ( subject_code varchar(10), school varchar(30), name varchar(10) ); CREATE TABLE Subject ( subject_code(10), school varchar(30), name varchar(10) ); CREATE TABLE Student ( student_id number(10), name varchar(10), address varchar(30), phone number(10) ); Table Description desc table School; Select * from School; Name                       Null              Type school_code Not null integer location Not null varchar(25) name Not null varchar(10)   desc table Professor; Select * from Professor; Name               Null              Type staff_id Not null number(10) name   varchar(20) school   varchar(30)   desc table Course; Select * from…