Branch(BranchNo, B_Street, B_Suburb, B_Postcode, Staff_No*, Start_Date, Monthly_Bonus, Telephone1, Telephone2, Telephone3, S_Name*) Staff(StaffNo, S_Name, S_Address, Position, Salary,Branch_No*, Supervisor_No) Property(PropNo, P_Street, P_Suburb, P_Postcode, Type, NoOfRooms, WeeklyRent, AvailableForRent, AdOnOtherWebsites, Staff_No*, S_Name*) 1. For each of these relations, write down all functional dependencies. If there are nofunctional dependencies among attributes, you must state so. Subject: MYSQL
Q: «extend» training course «include» add course «extend» basic course choose level course kextend»…
A: No of external entities: 1. Student 2. Database 3. System UI
Q: bläi 4 This code enter a number represents a Celsius degree (C) then converts it to Fahrenheit…
A: Explanation: According to the instruction in the given statements, If “F” is greater than or equal…
Q: AdminID CourselD CourseName AdminPassword CourseFees AdminName have Admin Course CourseDuration…
A: ER Diagram with relationship and key
Q: on named fnDateRange, similar to the stored procedure of exercise 3. The function requires two…
A: 6. Create a table-valued function named fnDateRange, similar to the stored procedure of exercise…
Q: The StayWell maintenance team wants to minimize the number of planned visits to properties. The team…
A: According to the information given:- StayWell maintenance team wants the minimum number of planned…
Q: Which of the following is FALSE with respect to Logical DFD? It shows only the collections…
A: Logical DFD: A logical data flow diagram will focus on the system process. It is used to illustrate…
Q: 8. In the following code below, the code selects an Employee object by primary key. However you…
A: The answer for the above given question is given below:
Q: Is it possible to control the integrity of a field by selecting a certain data type?
A: Integrity Refers To? Data integrity means complete accuracy, completeness, and reliability of data.…
Q: Books (isbn:CHAR(10), title: CHAR(20), author: CHAR(80), qty_in_stock: INTEGER, price: REAL,…
A: 1. To find ISBN of all books ordered by customer "John Doe" Find customer id of John Doe SELECT cid…
Q: 11- What will be the result after executing this statement: SELECT SUBSTR('Specialization', 1, 7)…
A: Given: 11- What will be the result after executing this statement: SELECT SUBSTR('Specialization',…
Q: 1. Create the GET_INVOICE_DATE procedure to obtain the customer ID, first and last names of the…
A: A stored procedure is a prepared SQL code that you can save, so the code can be reused over and over…
Q: The following code, using semaphores, will result in what kind of problem mutex.acquire();…
A: Given the following code we have to choose what kind of problem in the four options
Q: Salesforce Assignment: Mr. Abhishek is the client of the most valuable project of your company and…
A: Given:
Q: Courses(CNum, topic, fee, facID) Faculty(FacID, LName, Office, Dept) Give a relational algebra…
A: Answer: I have given answered in the brief explanation
Q: Question 6 Based on the code below, what will be logged to the console? function whichAnimal () {…
A: As per our guidelines we are supposed answer only first three subparts kindly post rest question…
Q: 1. Show vaccination status 2. Show vaccination status per priority group 3. Show vaccination status…
A: Solution: Code
Q: A(n) ___________________ is used within a simple condition to compare two values. A index B…
A: Answer: Option A: Index is used in arrays to present the position of the array values so this option…
Q: Q. Access control can be achieved by ____________________.
A: This is a control configuration based question in linux.
Q: want to make 2 pages ,1 balance ,1 deposit .that i go into the 2 pages ,and i can do changes on the…
A: In given code we create two pages balance and deposit so we can use partial helper.…
Q: Member (memberlD, memberName, joinDate) Game (gamelD, gameType, gameDate, gameWinner,…
A: Given SQL query contains four table with different attributes and those tables are: Member with…
Q: 19. A group of related fields, is known as a. file b. tuple c. records d. schema
A: Dear Student, A group of related field , is known as tuple. it is just a nomenclature so all the…
Q: Display the total amount HAFH spends on manager salaries (as TotalSalary) and the total amount HAFH…
A: Query1: select sum(MSalary)as TotalSalary from manager; Query2: select sum(MBouns) as TotalBouns…
Q: 78. Which of the following applies to a class rather than an object? a. Query b. Update c. Scope d.…
A: Given: 78. Which of the following applies to a class rather than an object?a. Queryb. Updatec.…
Q: Below code intends to use a variable grade to store a set of grades. Explain what is the syntax…
A: Note: As per Q and A guidelines we are only supposed to answer 3 sub parts of a question, so solving…
Q: oop using c++ please give me full answer thanks Write a program to declare a class ‘Result’ which…
A: Note: Comments are mentioned in the code for understandability. Code: #include<iostream>…
Q: Vhich of the following statements is correct? In a SELECT statement with WHERE and GROUP BY, groups…
A: SQL is structured query language which follows a set of rules before execution of query. It's…
Q: Design the Java FX Insurance Policy registration as follows. List view contains five policies as…
A: Answer: I have done code and also I have attached code as well as code screenshot. And this is not…
Q: print("Davy's auto shop services") print("Oil change -- $35") print("Tire rotation -- $19")…
A: print("Davy's auto shop services")print("Oil change -- $35")print("Tire rotation -- $19")print("Car…
Q: 1. The starter code has been created for you. 2. Using the Yahoo Finance module, download the stock…
A: The python code is given below:
Q: Create a list that shows each department name, # of employees, maximum salary, minimum salary, total…
A: First EMP and DEPT tables have to join basing deptno in both. Then group them by using dname. Then…
Q: Make the functions below according to the attached class diagram and GUI program mockup. No The…
A: Actually, java is a object oriented programming language. It is a platform independent.
Q: On the Attendance worksheet, in cell L5, enter an IF function to determine if the percentage in…
A: Required: On the Attendance worksheet, in cell L5, enter an IF function to determine if the…
Q: Enter the data of 10 students by creating the structure having members id, first_name, second_name,…
A: Start Input all details of Students in array Iterate over the array If id is same as searching id,…
Q: In cell B3, insert the SUMIF function to calculate the total orders for Austin (cell B1). Use…
A: ANSWERS:- PART 7:-
Q: Read your name, distance to college, cgpa and allowance. Find new allowance based on the following…
A: #include <stdio.h> #define MAX_LIMIT 20 int main() { char name[MAX_LIMIT]; // to input…
Q: 18. What is the best data type definition for Oracle when a field is alphanumeric and has a length…
A: Oracle Database is a multi-model cross-platform database management system developed by Oracle…
Q: A landline Telephone number contains 7 digits. How many Landline numbers can be formed if the first…
A: Here in this question we have asked to find total number of landline possible..if the first number…
Q: Create formulas that provide this information as follows: In cell H8, create a formula using the…
A: a) count of project less than 5000 using DCOUNT function : Answer :…
Q: Exercise 5.3 The following relations keep track of airline flight information: Flights(flno:…
A:
Q: Given the following Class table, write the DML statement to add a new class with the following…
A: SQL insert statement: In SQL, the insert query is a type of DML(Data Manipulation Language)…
Q: In cell G1, type Fast Track as the column heading. In cell G2, enter a formula using the AND…
A:
Q: Problem: Read your name, distance to college, cgpa and allowance. Find new allowance based on the…
A: As no programming language is mentioned so I am using python. In step 2, you will get python code.…
Q: Which of the following is an example of group function? a. UPPER b. COUNT c. CONCAT d. TRIM
A: Group functions are built-in SQL functions that operate on groups of rows and return one value for…
Q: Not allowed to add variables in brackets next to originIndex * @return index of the point…
A: ALGORITHM:- 1. Calculate the distance of the points from the origin. 2. Return the point with…
Q: I. IIstudent_id (Ostudent_name='C' and (Ostudent_id=1001 (STUDENT)) UTlemployee_id…
A: Note: As per our company guidelines we are supposed to answer only 3 sub-parts. Kindly repost other…
Q: The StayWell maintenance team wants to minimize the number of planned visits to properties. The team…
A: According to the information given:- Staywell team want minimum number of planned visit to…
Q: Requirements: Validate city code Total population >0 Total of fully vaccinated must be greater than…
A: Algorithm: Start Read name of city and validate it Read total population (pop) and validate it…
Q: In cell G2, enter a formula using the AND function that includes structured references to display…
A: Solution :: Let's see first what is Excel and why we used it ? Answer :: Microsoft Excel is an…
Branch(BranchNo, B_Street, B_Suburb, B_Postcode, Staff_No*, Start_Date, Monthly_Bonus, Telephone1, Telephone2, Telephone3, S_Name*)
Staff(StaffNo, S_Name, S_Address, Position, Salary,Branch_No*, Supervisor_No)
Property(PropNo, P_Street, P_Suburb, P_Postcode, Type, NoOfRooms, WeeklyRent, AvailableForRent, AdOnOtherWebsites, Staff_No*, S_Name*)
1. For each of these relations, write down all functional dependencies. If there are nofunctional dependencies among attributes, you must state so.
Subject: MYSQL
Step by step
Solved in 2 steps
- Publisher (name, phone, city), PK: name. Book (ISBN, title, year, published_by, previous_edition, price), PK: ISBN, FK: published_by refs Publisher, previous_edition refs Book. Author (SSN, first_name, last_name, address, income), PK: SSN. Write (aSSN, bISBN), PK: (aSSN, bISBN), FK: aSSN refs Author, bISBN refs Book. Editor (SSN, first_name, last_name, address, salary, works_for, book_count), PK: SSN, FK: works_for refs Publisher. Edit (eSSN, bISBN), PK: (eSSN, bISBN), FK: eSSN refs Editor, bISBN refs Book. Author_Editor (aeSSN, hours), PK: aeSSN, FK: aeSSN refs Author, aeSSN refs Editor. Give SQL statement for the following plain English language query based on the above schema. ---------------------------------------------------- Provide the title, year, and publisher name of every book and the first name and last name of the editor of the book. Note: publisher name is in Publisher table. so there are 4 tables that need to be traversed author, edit, editor, and then a publisher.…Publisher (name, phone, city), PK: name. Book (ISBN, title, year, published_by, previous_edition, price), PK: ISBN, FK: published_by refs Publisher, previous_edition refs Book. Author (SSN, first_name, last_name, address, income), PK: SSN. Write (aSSN, bISBN), PK: (aSSN, bISBN), FK: aSSN refs Author, bISBN refs Book. Editor (SSN, first_name, last_name, address, salary, works_for, book_count), PK: SSN, FK: works_for refs Publisher. Edit (eSSN, bISBN), PK: (eSSN, bISBN), FK: eSSN refs Editor, bISBN refs Book. Author_Editor (aeSSN, hours), PK: aeSSN, FK: aeSSN refs Author, aeSSN refs Editor. Give SQL statement for the following plain English language query based on the above schema. ---------------------------------------------------- Provide the title, year, and publisher name of every book and the first name and last name of the editor of the book. Note: publisher name is in Publisher table. so there are 4 tables that need to be traversed author,edit, editor, and then publisher.Publisher (name, phone, city), PK: name. Book (ISBN, title, year, published_by, previous_edition, price), PK: ISBN, FK: published_by refs Publisher, previous_edition refs Book. Author (SSN, first_name, last_name, address, income), PK: SSN. Write (aSSN, bISBN), PK: (aSSN, bISBN), FK: aSSN refs Author, bISBN refs Book. Editor (SSN, first_name, last_name, address, salary, works_for, book_count), PK: SSN, FK: works_for refs Publisher. Edit (eSSN, bISBN), PK: (eSSN, bISBN), FK: eSSN refs Editor, bISBN refs Book. Author_Editor (aeSSN, hours), PK: aeSSN, FK: aeSSN refs Author, aeSSN refs Editor. Give SQL statement for the following plain English language query based on the above schema. ---------------------------------------------------- Provide the title, year, and publisher name of every book and the first name and last name of the editor of the book.
- EXPERIMENTAL PROCEDURE Patients visit the hospital and their visit history is maintained by the hospital staff. Different physicians may be available on different dates. They diagnose and treat the patients of all categories. Some of treatments are free while others are to be paid by the patients. Sample data of the case is shown in the following chart. Patient History Report PatientID Name Address Visit Date Physician Diagnosis Treatment P-100809 A City: X 12-02-2007 20-02-2007 29-02-2007 15-03-2007 Dr. Z Dr. F Dr. R Dr. L Chest Infection Cold Hepatitis-A Eyes Infection Free Free Paid Paid P-200145 N City: Y 10-01-2007 15-02-2007 25-03-2007 Dr. L Dr. K Dr. A Bone Fracture Cough Flu Paid Free Free Task 1 Draw a dependency diagram and transform the above data to first normal form by eliminating repeating groups such that each row in the relation is atomic. Be sure to create an appropriate name for the…A unique identifier for a data row that consists of more than one field is commonly called a: primary plus key composite primary key foreign key none of the abovePlease refer to the following diagram for Q19 to Q20. PERSON PK P_ID P_LNAME P_FNAME ΕMPLOYΕ P_ID EMP_HIRE_DATE STUDENT P ID STUDY ΜAIOR PK, FK1 PK, FK1 19. Which of the following statements is/are true? (1) A Person must be either a Student or an Employee. (2) A Person can neither be a Student nor an Employee. (3) A Person must be a Student or an Employee or both. a. (1) only b. (3) only c. (1) and (2) only d. (1), (2) and (3).
- Having this information. StudentsAttribute Name Data TypeStudentID char(11)FirstName varchar(20)LastName varchar(20)Gender char(1)DateofBirth date CoursesAttribute Name Data TypeCourseCode varchar(6)CourseName varchar(70)Level char(2)Credits int RegistrationAttribute Name Data TypeStudentID char(11)CourseCode varchar(6)Grade decimal(2, 1) Write SQL code to: 1. What are the student ID, the names, and birthday of the female students who were born before the last day of 1992? 2. How many students are registered in the course “PHY210”? 3. How many courses are offered by the department of Computer Science (i.e. course codes CS***)? 4. Which course(s) (couseCode and courseName) of level G1 give 5 credits?Having this information. StudentsAttribute Name Data TypeStudentID char(11)FirstName varchar(20)LastName varchar(20)Gender char(1)DateofBirth date CoursesAttribute Name Data TypeCourseCode varchar(6)CourseName varchar(70)Level char(2)Credits int RegistrationAttribute Name Data TypeStudentID char(11)CourseCode varchar(6)Grade decimal(2, 1) Write SQL code to: 1. How many courses are there on each level? 2. What is the average grade of courses that have been taken by the student with student ID 861103-2438? 3. Which students (studentID only) have the highest grade for the course ‘CS052’? 4. Find the courses (course codes only) that have been taken by both the student 861103-2438 and the student 123456-0980.Database Schema The schema for the Ch07_FACT database is shown below and should be used to answer the next several problems. Click this image to view it in its own tab. FIGURE P7.56 THE CH07_FACT ERD CHECKOUT PATRON PK Check Num PK Pat ID FK1 Book_Num FK2 Pat_ID Check_Out_Date Check_Due_Date Check_In_Date >0-----H- Pat_FName Pat LName Pat_Type BOOK AUTHOR PK Book_Num PK Au ID Book_Title Book_Year Book_Cost Book_Subject FK1 Pat_ID Au_FName Au_LName Au_BirthYear WRITES PK,FK1 Book Num PK,FK2 Au ID The CIS Department at Tiny College maintains the Free Access to Current Technology (FACT) library of e-books. FACT is a collection of current technology e-books for use by faculty and students. Agreements with the publishers allow patrons to electronically check out a book,
- DataBase; You are required to develop a simple database application for a small recruiting firm that wishes to keep track of all the employees at the firm; storing details about their name, phone numbers, hiredate, Gender, Date of Birth, Salary, and Commission. The firm has many departments and there are 5 to 20 employees in each department. The department information includes department name, description and total number of employees in that department. The company also provides vehicles for some of its employees. An employee maybe allocated one car. To ensure timely maintenance of vehicle, the company would like to store the following details of the vehicle: make, model, next_maintenance_date. Each employee has a position (manager, accountant, administrator, clerk, HR employee, etc.). Various allowances are allocated to each position. For example, the managers have fuel allowance, house allowance, social allowance and managers allowance. On the other hand, the administrators have…Customer ={idC(PK), surname} Contract ={idC(PK), customer, consultant, insurance_type, date} Consultant means: id of some Staff member Staff={idPerson(PK), surname,dob, boss, email} Dob means: date of birth, boss: is id of another Staff member supervisor Insurance_Type={idT(pk) , Tname , price , length } Length = number of months it is valid (from the date when it was bought ) Find consultants born after some contract was already signed?DATABASE: library (library_name [pk], City, Phone, manager_SSN[pk, fk]) book (book_name [pk], Genre, Country) borrower (SSN[pk], Name, Birthyear, Fav book [fk], Gender) likes (SSN[pk, fk], book [pk, fk]) bookLoans (library [fk], books [fk]) manager (SSN[pk], Name, City, Address, Phone) Provide OPTIMIZED relational algebra for the following queries: 1 a) List name, gender, and age of all borrowers. b) List all male borrowers older than 65 years of age. c) List the book names loaned by at least one library and liked by at least one borrower. d) List the name and ssn of all borrowers who like their favorite book