need help with this two quieries. students(sid,name,age,gpa) // sid is the primary key courses(cid,deptid, description) // cid,deptid is the primary key professors(ssn,name,address,phone,deptid) // ssn is the primary key enrollment(sid,cid,section,grade) cid makes reference to the courses table. // sid, cid, and section is the primary key teaches(cid,section,ssn). cid, section makes reference to the enrollment table // cid, section is the primary key a. List of professors that work for departments with more than 20 faculty members and that offer more large sections than small and medium sections combined. b. Assume grades are A, B, C, D, F where D and F are failing grades. For each course (section) find the percentage of students that failed the course.

Q: age gender customer ID Customers first_name name zip code last_name makes total transaction_date…

A: 1. Customers Relation (i) Name of the relation: Customers (ii) Names of its…

Q: Tasks: Considering the following E-R diagram, you need to translate it into a relational database…

A: An Entity-Relationship (ER) diagram is a visual representation of the entities (objects),…

Q: Required: Convert the E-R diagram you designed in last exercise into a relational database schema. •…

A: For question 1, You have not provided the ER diagram you designed in the last exercise, so we can't…

Q: latitude ER Diagram longitude description Convert to relation schema location last_visited

A: A rеlational schеma is a bluеprint for a rеlational databasе. It dеfinеs thе tablеs in thе databasе,…

Q: 35. Key to represent relationship between tables is called a. Primary key b. Secondary Key c.…

A: Please find the answer to the above question below:

Q: Schema: Part(PartNo, PartName, VehicleType, UnitPrice, SalesPrice) Service(ServiceNo, PartNo,…

A: CREATE OR replace FUNCTION getprofit (    p_part_number IN NUMBER) RETURN NUMBER IS    l_part_name…

Q: Which one of the following statement is not true: A complex object is formed by combining other…

A: The above question is solved in step 2 :-

Q: Construct appropriate relational schemes for each of the E-R diagrams below.

A: paper(title, author) cite(title) Explanation: The attribute "title" is the primary key for the…

Q: Implement a new independent entity phone in the Sakila database. Attributes and relationships are…

A: There is only one error in the above code and that is the ALTER TABLE command on the address table.…

Q: REGION Region ID Region Name Belongs To ASSIGNMENT Score Hours Rate PROJECT Proj ID Proj Start Date…

A: ERD stands for Entity Relationship Diagram and it contains mainly three components that are…

Q: Using SQL, develop and execute the following queries:

A: 1.  select sname,sid from student where gpa>2.5 AND gpa<=3.5; 2. select s.sname,c.cname from…

Q: Task 4: As a part of marketing strategy, the Marketing team continuously conducting an advertising…

A: Actually, database is a used to stores the data.

Q: Implement a new independent entity phone in the Sakila database. Attributes and relationships are…

A: SQL: Database management is done using a programming language called SQL, or Structured Query…

Q: CUSTOMER Ữ CustomerID FirstName LastName Phone EmailAddress INVOICE InvoiceNumber Customer D Dateln…

A: Schema Structure- --------------Customer---------------- CustomerID (Primary Key)- FisrtName-…

Q: Based on the above relational schema you are required to draw the Entity Relationship Diagram (ERD).…

A: ER Diagram

Q: Indicate the changes (using the shorthand representation) that you would need to make to the…

A: Question 1.) Indicate the changes (using the shorthand representation) that you would need to make…

Transaction Processing

Transaction processing is a computational style generally performed by server computers, which supports interactive applications (apps). Transaction processing is also known as information processing, which divides the work into indivisible and individual operations called transactions. The transaction is a set of tasks; a single task is considered as the minimum processing unit that cannot be divided again.