26, 'Kampung Buah Mangga Harum Manis No. 5B')ScoreComponent table (Component, Description, Weight)INSERT INTO Score Component VALUES('ASG', 'Assignment', 30.00)INSERT INTO Score Component VALUES('MID', 'Mid Test', 35.00)INSERT INTO ScoreComponent VALUES ('FIN', 'Final Test', 35.00)Weight table (Grade, ScoreMin, ScoreMax, Weight)INSERT INTO [Weight] VALUES ('A, 91, 100, 4.00)INSERT INTO [Weight] VALUES ('A-, 86, 90, 3.67)INSERT INTO [Weight] VALUES ('B+', 81, 85, 3.33)INSERT INTO [Weight] VALUES ('B', 76, 80, 3.00)INSERT INTO [Weight] VALUES ('B-, 71, 75, 2.67)INSERT INTO [Weight] VALUES ('C+, 66, 70, 2.33)INSERT INTO [Weight] VALUES ('C', 61, 65, 2.00)INSERT INTO [Weight] VALUES ('D', 50, 60, 1.00)INSERT INTO [Weight] VALUES ('E', 1, 49, 0.00)INSERT INTO [Weight] VALUES ('F', 0, 0, 0.00)question:make query for:StudentID StudentName SemesterCreditSemesterGPA-ICXN)SCGPA (Grade Point Average)• Semestral GPA (GPS). Semestral GPA refers to the GPA of a given semester.• Cumulative GPA. Overall Average GPA is calculated from a student's first semester of enrolmentup to the last semester attended.GPA is the measurement of student's performance, calculated by:SemesterGPAWhere C is the credits earned from the course and N is theweight earned based on the letter grade.CreditCumulative GPACumulative

The Final answer will contain 7 tables: StudentScoreDetail table StudentScore table Course table…

make query for: StudentID Student Name Semester Credit Semester GPA-ICXN) SC GPA (Grade Point Average) • Semestral GPA (GPS). Semestral GPA refers to the GPA of a given semester. • Cumulative GPA. Overall Average GPA is calculated from a student's first semester of enrolment up to the last semester attended. GPA is the measurement of student's performance, calculated by: Semester GPA Where C is the credits earned from the course and N is the weight earned based on the letter grade. Credit Cumulative GPA Cumulative

make query for: StudentID Student Name Semester Credit Semester GPA-ICXN) SC GPA (Grade Point Average) • Semestral GPA (GPS). Semestral GPA refers to the GPA of a given semester. • Cumulative GPA. Overall Average GPA is calculated from a student's first semester of enrolment up to the last semester attended. GPA is the measurement of student's performance, calculated by: Semester GPA Where C is the credits earned from the course and N is the weight earned based on the letter grade. Credit Cumulative GPA Cumulative

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Write Create Table SQL statements Work Session table The table must have a primary key. The table must have appropriate foreign key constraints. Foreign keys must have the same name, datatype and size of the primary key that they refer to The following columns datatypes and sizes and named constraints must be used Column DataType Constraint WorkYear number(4) Range 2019 - 2020 WorkWeek number(2) Range 1-52 WorkHours number(4,2) Range 0.5 – 99.99 BID NUMBER(4) ,AUTHID NUMBER(4)
Some rows of the STUDENT table are shown below: CODE NAME GPA YEAR 291 ALEX 3.1 2 938 MICHELE 2.3 1 931 JHON 3.3 1 182 JOE 3.4 2 190 REY 2.0 2 330 RON 3.9 3 Which best describes the result of the query below? SELECT YEAR, AVG(GPA) FROM STUDENT WHERE GPA > 2.0 GROUP BY YEAR a. The average maximum GPA of all the students in each year. b. The year of the student with the maximum GPA. c. The average GPA of students with a GPA higher than 2.0 each year. d. The average GPA of the students with a GPA higher than 2.0.
SQL DML/DDL There are five tables describing employees of a company, departments, buildings, which department(s) an employee works in (and a percentage of the time for each), and in which building an employee works (an employee may have more than one office). The primary key of each table is the attribute(s) in capitals and underlined. The foreign keys are in italics. Other attributes are not necessarily unique.Employee (EID, Ename, Salary, Start_Date, End_Date)Building (BID, Bname, Address)Department (DID, Dname, Annual_Budget)In_Department (EID, DID, Percentage_Time)In_Building (EID, BID)Write the SQL statements for the following.1. Find the names of Departments where NO employees work. 2. For employees who are still working in the company, end date has no value (empty). For those who have left the company and have end date values, show their names and the duration of their employment in years. 3. Find the names of buildings where more than 50 employees work. 4. The tables have…
SQL QUERIES Employees(EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE,JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID,DEPARTMENT_NAME)Department(DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID, LOCATION_ID)Location(LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) Write a query in SQL to display the DEPARTMENT_NAME of all those Departments whoseDEPARTMENT_ID is greater than the DEPARTMENT_ID of Physics department. Write a Query in SQL to show the FIRST_NAME of all those employees whose salary is lessthan the salary of all those employees whose MANAGER_ID is 101 or 102.
calculate_new_balance Given a starting balance (a number), and a list of transaction tuples, calculate the final balance for an account. Transaction tuples are of the shape ("description", amount, "withdrawal") , or ("description", amount, "deposit"). The last entry in the tuple will be either "withdrawal" or "deposit". Every withdrawal decreases the balance of the account by the specified amount, and every deposit increases the balance. The return value is the new account balance, as a number. (which could be negative) Sample calls should look like: >>> calculate_new_balance(100, [("payday", 20, "deposit"), ("new shoes", 50, "withdrawal"), ("illicit winnings", 200, "deposit")])270>>> calculate_new_balance(100, [])100
1. Make a table of five columns “Name", “Midterm Score", “Final Term Score" , “Average" and Grade. Below 60 = F Above 60 =D Above 70 = C Above 80 = B Above 90 = A
WorksOn Database: Employee (EmployeeNumber, EmployeeName, BirthDate, Title, Salary, DepartmentNumber) Project (ProjectNumber, ProjectName, Budget, DepartmentNumber) Department (DepartmentNumber, DepartmentName, ManagerNumber) WorksOn (EmployeeNumber, ProjectNumber, Responsibility, Hours) Questions: 1) Write an SQL query that returns the project number and name for projects with a budget no greater than $1,050,000. 2) Write an SQL query that returns all works on records where hours worked is less than 5 and the responsibility is 'Manager'. 3) Write an SQL query that returns the employees (number and name only) who have a title of 'EE' or 'SA' and make more than $50,000. 4) Write an SQL query that returns the employees (name and salary only) in department 'D1' ordered by decreasing salary. 5) Write an SQL query that returns the departments (all fields) ordered by descending department name.
Schema: Frequents(kid, store) Sells(store, candy) Likes(kid, candy) d) Use SQL to list the names of all the candies that are liked by at least one kid, along with the names of the stores that sell them. Sort the result in alphabetical order by candy name.
Computer Science A study conducted by Netflix’s consumer relations department has revealed that customers are more likely to review horror and thriller movies during certain months of the year. To discourage seasonal variations in these movie ratings, Netflix has called for your help to analyze horror and thriller movie rating counts over the past 15 years. Your query should display each month of the year (name of the month not the number) and the total number of ratings given during that month. A third column titled “Promotion Recommendation” determines whether a promotion should be applied to increase the number of ratings given during that month. If a month has less than 2200 ratings the final column should display ‘10% discount promotion’, if between 2201 and 4500 then display ‘5% discount promotion’, and if more than 4500 ratings then output ‘No Promotion’. Order your results by months. Do not hardcode the current date. ORALCE CODE PLEASE.
SQL Database Write PL/SQL or T-SQL procedures to retrieve and output the reservation ID, trip ID, number of persons, and trip price for every reservation whose customer number is stored in I_CUSTOMER_NUM
**In SQL** Write a SELECT statement that returns these columns: InstructorDept The DepartmentName column from the Departments table for a related instructor LastName The LastName column from the Instructors table FirstName The FirstName column from the Instructors table CourseDescription The CourseDescription column from the Courses table CourseDept The DepartmentName column from the Departments table for a related instructor Return one row for each course that’s in a different department than the department of the instructor assigned to teach that course. (Hint: You will need to join the Departments table to both the Instructors table and the Courses table, which will require you to use table aliases to distinguish the two tables.)
C sharp Table: Student (the headers are the field names in the Students table) StudentID Name Age Gender ProgramID 791 Stephanie Brown 19 Female BCS 236 Shannon Dawn 25 Female BA 618 Geoff Berg 24 Male ARET 256 Andrew Schilling 22 Male BSC 902 Gary Sang 23 Male DAAD Note: There is a StudentDataSet with a Student table, a StudentTableAdapter, a StudentBindingSource, and a StudentDataGridView control on the form.Note: There is an Average query, named Average, that returns the average age of the student from the Student table.Note: There is also Max query, named Highest, that returns the highest age of the student from the Student table.Write the code you would place in the AverageButton click event on your form to call the Average query and the Highest query and display in a DifferenceLabel, the difference between the highest age of a student and the average age.