Computer Lab 4a

Solve question number 2

T Shirt Sales t-shirt price quantity sold total revenue $15 400 $6,000 50 100 150 200 250 300 350 400 $10 $15 $17 $25

Question 7: Build a table to show the frequency of each offence category. Arrange the frequency in descending order. Which two categories have the most offences issued q7 * COffence category) *>* q7 The highest two frequency of offences are and Question 8: Draw a suitable plot to show the same information as in Question 7 but just restricted it to the highest 5 categories. Look at the lasi line of coding, what this coding is trying to do? It is just to make the label more visible by rotating the label. q7 *>* top_n(5) %>* ggplot (aes (x --- y = theme (axis. text.x - element_text (angle=45, hjust = 1))

Use the following diagram relation to perform the normalization. You need to provide the 2NF and 3NF.

One hundred students were asked whether they had taken courses in any of the three subjects, Mathematics, Computer Science and Information Technology. The results were given below. 45 had taken Mathematics; 18 had taken Mathematics and Computer Science; 38 had taken Computer Science; 21 had taken Information Technology; 9 had taken Mathematics and Information Technology.; 4 had taken Computer Science and Information Technology and 23 had taken no courses in any of the subjects. Draw a Venn diagram that will show the results of the survey.

Create ERD for the given case study using Crows Feet Notation.

Create ERD for the given case study using Crows Feet Notation.

Add the ends to the relations on the Crows Foot ERD for the business rules of the XYZ Company's motor pool (a motor pool typically is a group of vehicles that are temporary assigned to employees to drive for business purposes): a. Each time an employee wants a vehicle a new assignment is made. b. An employee can have multiple assignments, but each assignment is for only one employee and only one vehicle. c. A vehicle may have multiple assignments. d. The XYZ location at the end if the assignment is stored in the assignment. It is assumed tht the assignment begins at the destination of that vehicles prior assignment. e. An assignment may have the status of Assigned, Out, or Returned. f. A vehicle may only be "Out" on one assignment and an employee may only have one assignment "Out". VEHICLE EMPLOYEE 1 7 STATUS 34 ASSIGNMENT 56 2 8 00 LOCATION

Convert the Entity Relationship Diagram in to relational database by using MS Access (Note: Students has to create tables in the MS Access by giving appropriate Primary key and Foreign key relationships) QI. Customer Order OrderDetail CustomeriD OrderiD OrderiD (FK) OrderDetaillD Name Mail ZipCode Address Telephone CustomeriD (FK) OrderDate TotalPrice ProductiD (FK) Amount Price Product ProductiD Name Kind Price

Use the following diagram relation to perform the normalization. You need to provide the Dependency Diagram and 1NF.

I am working on creating a logical entity relationship diagram for my database class. I am wondering if I am creating my diagram correctly. I'm having a hard time finding primary and foreign keys and I'd like to make sure the cardinality for my diagram is correct.

Consider the following relation : STUD Class 4 3 4 4 2 Age 19 18 11 10 6 Sname Vikas Shreya Megha Rajan Ritu Let us suppose 'x' is a tuple variable ranging over 'STUD' relation. Following TRC expression is given: vx(~(x.class = 4) Vx.age < 10) What are the number of tuples that are valid according to the above TRC query:

) Show the detailed results achieved by a specific student sid= ‘S0001’. For each course taken by the student, show the course ID, title, name, weighting and mark achieved for each assessment. Show the course ID and the student’s final result (weighted average) for each of the courses they have taken.

For a given relationship set, R = {A, B, C, D, E, F} and FD : A->B, C->D, E->F . Calculate F+ of A, B, C, D, E, F and find the candidate key from this relationship. Do you think this relation is in 2NF form? why or why not?

IN SQL, POSTGRESQL. For customer, product and state, show the average sales before and after eachquarter (e.g., for Q2, show average sales of Q1 and Q3. For “before” Q1 and “after”Q4, display . The “YEAR” attribute is not considered for this query – forexample, both Q1 of 2017 and Q1 of 2018 are considered Q1 regardless of the year. Report #2:CUSTOMER PRODUCT STATE Q1 BEFORE_AVG AFTER_AVG======== ======= =====   == ==========   =========Bloom Bread NJ 1 2434Sam Milk CT 3 254 325

What is the degree of a relationship? Give anexample of each of the relationship degreesillustrated herein.

Consider the following entity relationship diagram. Booking Employee Room Building • Booking ID • Employee ID • Building ID • Room ID • First Name • Room ID P • Name Description • Employee ID • Name Last Name • Date • Campus Zone • Email Address • Capacity • Start Time • Map Coordinates Phone • Bookable • End Time For each statement below, use the drop-down box to indicate whether it is true (answer 1) or false (answer2), according to the design decisions encoded in the ERD. Every booking is associated with exactly one employee. ✓ Every employee is associated with at most one booking. ✓ A building may contain no rooms that are recorded in the database. Each room may have many bookings. 1. True ✓ A room must have at least one booking. 2. False ✓ A booking can be associated with many employees. An employee may have no phone number recorded. ✓ A room must have its capacity recorded. ✓ A building is uniquely identified by its map coordinates.

An EMPLOYEE has only one JOB_CODE, but a JOB_CODE can be held by many EMPLOYEEs. An EMPLOYEE can participate in many PLANs, and any PLAN can be assigned to many EMPLOYEEs. Note also that the M:N relationship has been broken down into two 1:M relationships for which the BENEFIT table serves as the composite or bridge entity. Question: Create the ERD to show the relationships among EMPLOYEE, BENEFIT, JOB, and PLAN.

A college course may have one or more scheduled sections or may not have a scheduled section. Attributes of COURSE include Course ID, Course Name, and Units. Attributes of SECTION include Section Number and Semester ID. Semester ID is composed of two parts: Semester and Year. Section Number is an integer (such as 1 or 2) that distinguishes one section from another for the same course but does not uniquely identify a section. How did you model SECTION? Why did you choose this way versus alternative ways to model SECTION?

There are two types of tables X and Y, let assume the X is the shorter one and Y is more longer. the combination must be occurred between the two types of tables to be aligned and filling up the given distance. We can use a few number of tables to cover all the required distance as possible. Hence, you are required to find the optimum combination to keep the remaining empty distance is as small as possible. [Hint: the first priority is to minimize the empty distance, and the second priority is to minimize the number of used tables] 00 Examples: Input: X = 3, Y = 5, D = 24 The optimum combination is: TX = 3, TY = 3, RD = 0 It means: three tables of size X (TX), three tables of size Y (TY), and remaining distance (RD) is 0. 3* 3+3* 5 = 24 So empty distance = 24 - 24 = 0 Input: X = 3, Y = 9, D = 29 Output: TX =0, TY = 3, RD = 2 It means: zero tables of size X (TX), three tables of size Y (TY), and remaining distance (RD) is 2. 0* 3+3* 9 = 27 So empty distance = 29 - 27 = 2 1- Design an…

There are two types of tables X and Y , let assume the X is the shorter one and Y is more longer. the combination must be occurred between the two types of tables to be aligned and filling up the given distance. We can use a few number of tables to cover all the required distance as possible. Hence, you are required to find the optimum combination to keep the remaining empty distance is as small as possible.[Hint: the first priority is to minimize the empty distance, and the second priority is to minimize the number of used tables] Examples: Input: X = 3, Y = 5, D = 24 The optimum combination is: TX = 3, TY = 3, RD = 0 It means: three tables of size X (TX), three tables of size Y (TY), and remaining distance (RD) is 0. 3 * 3 + 3 * 5 = 24 So empty distance = 24 - 24 = 0 Input: X = 3, Y = 9, D = 29 Output: TX =0, TY = 3, RD = 2 It means: zero tables of size X (TX), three tables of size Y (TY), and remaining distance (RD) is 2. 0 * 3 + 3 * 9 = 27 So empty distance = 29 - 27 = 2 Design an…

please help me write a latex/overleaf code for a table to be used for a weight decision matrix similar to the one depicted in the following figure, I don't know how to merge the cells at the top for each design     Design 1   D2   D3   D4   D5   D6   Criteria(C) Weight Rating(R) Weight Score(WS) R WS R WS R WS R WS R WS C1                           C2                           C3                           Total

Given 3-way BTree created by these data: 3, 7,9, 23, 45, 1, 5, 14, 25, 24, 13, 11 1. Draw the final BTree. 2. Draw the final BTree after adding these further keys (from your answer in #1) 2, 6,12 3. Draw the final BTree after deleting these keys using successor (from your answer in #2) 5, 7, 23

2. How do you construct the profile matrix?

Relation Schema: o (Selection) | I (Projection) | N/U7- (Set operations) | | (Join operation) employee(employee-name, street, city) as E works(employee-name, company-name, salary) as W company(company-name, city) as C manages(employee-name, manager-name) as M 1. Find the names of all employees in the database who earn more than 100k. 2. Find the names of all employees in the database who live in the same city as the city of their companies. 3. Find the employee's name who earn more than his/her manager.

If an employee can work for only one department and a department can have many employees (one to many relationship). Which answer the relationship table "work" that has the best values to describe the relationship between employee and department? The employee table has two columns (eid, name) with records ('E1','A'), ('E2','B'), ('E3','C'). The department table has two columns (did, name) with records ('D1','X'), ('D2','Y'), ('D3', 'Z'). work(eid, did) with values ('E1','D1'), ('E1','D2'), ('E2,'D2'). work(eid, did) with values ('E1','D1'), ('E2','D2'), ('E3,'D2'). work(eid, did) with values ('E1','D1'), ('E2','D2'), ('E2,'D3'). work(eid, did) with values ('E1','D1'), ('E2','D2'), ('E3,'D3').

Can you just draw this out on a piece of paper with the relationships??