4.1) For the following entity relationship diagram write MySQL code for creation of three tables. You can assume reasonable datatypes and lenfor each attributeWORK ALLOCATIONhasINTEGERPK,FK1 StaffIDINTEGERPK,FK2 DepartmentID INTEGERVARCHAR(30)PK StaffIDSTAFFStaffNameDateOfBirth DATETIMESalaryDECIMAL(10,2)PercentageTime DOUBLEinvolvesDEPARTMENTmanagesPK DeparmenttID INTEGER-OHFK1DepartmentName VARCHAR(30)BudgetManagerIDDOUBLEINTEGER4.2) The book database has the following Relation Schema:Author (AuthorNum, AuthorLast, AuthorFirst)Publisher (PublisherCode, PublisherName, City)Book (BookCode, Title, Publisher Code, DateFirstPublished, Type, Price, Paperback)Branch (BranchNum, Branch Name, Branch Location, City, NumEmployees)Inventory (BookCode, Branch Num, OnHand)Wrote (BookCode, AuthorNum, Sequence)Using the above schema, write MySQL statements for the following queries (a & b):a. Find the books whose prices are more than the average books price.b. List publisher names and their locations for those publishers that have the letter r in the third position of their names.11=

4.1) Here's the MySQL code to create the three tables based on the provided ER diagram: CREATE TABLE…

Answered: 4.1) For the following entity…

Similar questions

Consider the relations Courses1, Courses2, _Enrollment and Students. Courses1 Location cid cname Al Calculus LI A2 Algebra L2 A5 English L3 Student(sid, sname, age, level) Courses2 cid A5 BI B2 name English History b) Courses 1-Courses2 L3 L4 Computing L5 c) Courses Courses2 Classroom d) Courses1 Enrollment (1) Give the results of the following relational algebra expressions: a) Teid ( name='History' OR 'Computing (Courses2)) e) Enrollment / Teid (Courses1) Enrollment cid Al A5 sid 101 102 103 102 102 B1 Al A2 (2) Write the following query in Relational Algebra. a) Find the sids of students who have enrolled in _course Calculus. b) Find the names of students who have enrolled in course Calculus. _c) Find the names of students who have enrolled at least one course. d) Find the names of students who have enrolled in _Calculus or Algebra. e) Find the sids of students who have enrolled in all courses (both Courses1 and Courses2).
Map the EER diagram to a relational schema and transform the relation into 3NF
Murach's SQL Server 2019 for Developers Create an Entity Relationship diagram using Visio or visual-paradigm or Lucidchart or other sources. You will look at page 313 of your textbook and recreate the middle example that includes the Employees, Membership, and Committees tables.
Map the EER diagram to a relational schema and transform the relation into 3NF
I'm having trouble with this question with my data modeling class. " Scenario: Jonny is appointed as an intern position, which might lead to a junior database architect role in TechTrend Corporation (TTC). Jonny is assigned to redesign two legacy tables related to "Suppliers," to be normalization compliant. The following business rules are provided. Business Rules: 1. Suppliers can be local or national, thus can have multiple locations. 2. Any location can supply items to TechTrend. 3. Any location manager can have a separate pricing deal with TechTrend, based on production process specific to that location and localization efficiency. 4. Each location has a contact person assigned to TechTrend. 5. Traditionally, TechTrend dealt with a singular location, at the most two. With rapid growth in business, the TTC officials are finding better leverage possibilities to negotiate beneficial terms with suppliers in multiple locations. 6. The DB administrator has specifically requested Johnny…
Consider the following ER diagram. Attribute 'Code' is an example of a for entity FARE. Airport_code City State Name AIRPORT Company M CAN_ LAND N Type_name Max_seats AIRPLANE TYPE TYPE N Airplane_id AIRPLANE Seat_no SEAT Scheduled_dep_time Dep_time Total_no_of_seats Customer_name DEPARTS N N ASSIGNED DEPARTURE AIRPORT N ARRIVES ARRIVAL AIRPORT RESERVATION N Cphone Scheduled_arr_time Arr_time N N INSTANCE_OF Instances N Number Airline Weekdays Restrictions Amount Code No_of_avail_seats LEG_INSTANCE Date Leg_no FLIGHT LEG N LEGS FLIGHT 1 FARES N FARE Notes: A LEG (segment) is a nonstop portion of a flight A LEG_INSTANCE is a particular occurrence of a LEG on a particular date.