(1) Retrieve the names (fpame.Jname) of employees who work more than 11 hours per week on the 'TSU' project. (“TSU" is project name.) (2) Retrieve the names (fpame, Iname) of all employees who work on at least one project. (3) Retrieve the locations of “EEE" department. (“EEE" is department name).
Q: Tasks Review the peronal traner fact-finding summary and draw an ERD with cardinality notation.…
A: Personal trainer: The below given ERD defines the basic purposes involved in the personal training…
Q: A database at a college is required to support the following requirements. Complete the…
A: DBDLis a database design language which is represent by table by list all columns with using…
Q: Produce a list of the names of all employees who work on the Biometric project. Produce a report of…
A: Given employeee , department, project, workson tables they are joined tables. Using the given keys…
Q: Create ERD or EERD of a hospital with these requirements: write DB relational schema draw all…
A: answer is
Q: u must design a Microsoft Access database file for managing project & employee data with tables,…
A: The given problem is related to MS Access where the database tables are to be created with given…
Q: Which of the following tools is not used for process descriptions? a. Structured b. Pseudocodes c.…
A: 93. Which of the following tools is not used for process description? a. Structured b. Pseudocodes…
Q: Given the below list, “Record”, that includes 2 sub lists. The first includes the names, while the…
A: Record = [["Ali", "Mazen", "Fida", "Nader", "Majd"], ["Tutor", "IT", "Manager", "PR", "Clerk"]]Sal =…
Q: 33. Which of the following could cause data to be unavailable? a. Data becoming lost or inaccurate…
A: Here is the solution which is mentioned below:
Q: What is View Resolution and View Materialization?
A: Given: View Resolution and View Materialization?
Q: ____ is a single item of information about a person, place, or thing—such as a name, a salary…
A: Fied is a single piece of data which are arranged into records containing information belonging to…
Q: Question - 4 For each department retrieve the department number, number of employees and their…
A: by bartleby guidelines i am able to do only first question.
Q: A student database is to be maintained by the institute for placement. The student record should…
A: Due to company policies I am compelled to solve only one question and that is the first question.…
Q: Department: (DID, Department_Name, City, budget) Works IN: (EID, DID, Annual_Salary, Start_Date)…
A: T1: π(Employee_name, Annual_Salary) (Employee ⨝(Employee.EID = Works_IN.Employee_ID) Works_IN…
Q: Please provide some instances of data that does not fall within the purview of the Security Rule
A: Here Security means no restriction is applied and instances are basically examples. Instance are to…
Q: Personnel, department, project and employee relationship schemes defined for a company database are…
A: 1) QUERY - table "personal' LEFT JOIN with table "personal" will get the result SELECT…
Q: Structure: defines how data are structured, e.g., files, relations, objects. Integrity rules: define…
A: 1) structure(how the data's structured): It specifies how the data is organized. Data structure…
Q: the following dependencies, convert the following schema to 3NF PatientNo, PrescriptionNo ->…
A: It is defined as a relation is in third normal form, if there is no transitive dependency for…
Q: G: Race conditions can be occurred in any computer program. Consider a group of two students develop…
A: Given data G: Race conditions can be occurred in any computer program. Consider a group of two…
Q: Personnel, department, project and employee relationship schemes defined for a company database are…
A: Note - As per the guidelines we're only allowed to answer 1 question with 3 sub parts at a time.…
Q: a) What normal form is the above table in? Give reasons for your answer. b) Identify the primary key…
A:
Q: Create a login screen description document for this system that contains at least eight basic…
A: the login form includes two inputs, links to alternative scenarios, and a submit button. Even though…
Q: Write a memo to all staff on the subject of Recurring data security issues
A: Solution:
Q: a. The following pair of concepts are related in some way and different in another. Explain how the…
A: a) Similarities: Table: It is a collection of rows and columns. Here, all the rows are…
Q: reate a list of EMPNO, ENAME, HIREDATE, DEPTNO from EMPLOYEE for employee’s with a salary (SAL)…
A: Note: Since you have not provided the language or database name to write the code so I am using SQL…
Q: What are the major considerations when you were creating your secondary sub-sets of data? Enumerate…
A: We need to discuss the major considerations, when we create secondary sub-sets of data.
Q: Given the following declaration of records and the name of the records, write the full program to…
A: First we have to create table for both case then we have to input the values.
Q: 1. Which SQL statement inserts data into a table called Projects? a) INSERT Projects ('Content…
A: Introduction: Structured Query stands for Structured Query Language. Language is a programming…
Q: 33. The partitions of the database into fixed length storage units are called as __________ a.…
A: please see the next step for solution
Q: Fill in the phases of the Database Life Cycle (DBLC): Behavior of Answer Shape/Pocket: Shapes can be…
A: Phases of Database lifecycle(DBLC) are: 1) Database Initial Study 2) Database design 3)…
Q: A)@who are working on projects that are located in Houston. ast name. Make a list of the SSN of all…
A: Retrieve the names of employees who work on all the projects in which the employee with ssn…
Q: Assume a database of Employees of a company have been given as shown below: Employee: Projects:…
A: This question is related to Database management system. Here, I'm going to write SQL queries for…
Q: repare an Excel sheet which should contain the data of inpatient. Following parameters should be…
A: Required: Prepare an Excel sheet which should contain the data of inpatient. Following parameters…
Q: Complete the following task. Design a database to produce the following reports. Do not use any…
A: DBDL stands for the Database Definition Language. It has some particular standard format to…
Q: Functional dependencies Patient_id --> p_name, phone,email,home_address…
A: Step 1:- Given:- Functional dependencies:- Patient_id --> p_name, phone,email,home_address…
Q: ERD conditions: Read Need to know the date and content of the reading. i. The storage of previous…
A: ERD An Entity Relationship Diagram (ERD) is a depiction of information structures. An Entity…
Q: Topic: Database Design What are some concerns about using a date (or date time) as a primary key?
A: Primary Key: A Primary Key is a key value in database or a relational database which is unique for…
Q: art A - Database design case study In this part, you need to provide a short description of the…
A: Lets see the solution.
Q: ionary B- The attribute; the entity C- The entity; the attribute
A: given - Data standardization usually focuses on fixing _ of data while data cleaning usually…
Q: A logical description of some portion of database that is required by a user to perform task is…
A: Required; A logical description of some portion of database that is required by a user to…
Q: A collection of related information is known to be a. Database b. Reports c. Files d. Paging
A: 1) Database is a collection of related information stored on a computer. 2) These releated…
Q: 1) Given the View, which of the following statements are valid? CREATE VIEW DEPT_SUMMARY (D, C,…
A:
Q: Consider a MOVIE database in which data is recorded about the movie industry. The data requirements…
A: Given constraints Consider a MOVIE database in which data is recorded about the movie industry. The…
Q: Consider the File Structure for the XYZ Company Project Management data given below. Then,…
A: Given: A File Structure for the XYZ Company Project Management data consisting of several fields.…
Q: a. List of colleges sorted by zip code. b. Access to information on a specific lecturer—their name,…
A: For performing the operations, the SQL queries are:
Q: Create a login screen description document for this system that contains at least eight basic…
A: Answer 1. Create a system login screen description document for library with eight basic fields.…
Q: Provide the course code and description for any courses having a four-day duration. 2.2 Which…
A: the answer for the problem is given in the form of query and answer both forms
Q: A file that is organized in uniform format is formally referred to as a _____ or a database file. a.…
A: A file that is organized in uniform format is formally referred to as :
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
- Given the following relational schema of a database library (primary keys are underlined and foreign keys are preceded by #): Student(studentNumber, StudentName, studentAddress) Book(bookNumber, bookTitle, #authorNumber, #editorNumber, yearEdition) Author(authorNumber, authorName, authorAddress) Editor(editorNumber, editorName, editorAddress) Borrow(#studentNumber, #bookNumber, borrowDate, returnDate) Write the following queries in Relational Algebra: Find the details of students who borrowed the book titled ‘Database Management Systems’Given the following relational schema of a database library (primary keys are underlined and foreign keys are preceded by #): Student(studentNumber, StudentName, studentAddress) Book(bookNumber, bookTitle, #authorNumber, #editorNumber, yearEdition) Author(authorNumber, authorName, authorAddress) Editor(editorNumber, editorName, editorAddress) Borrow(#studentNumber, #bookNumber, borrowDate, returnDate) Write the following queries in Relational Algebra: List the details (bookNumber, bookTitle) of books whose author’s name is ‘Ramakrishnan’A University database is described by the following relational schema. Student (StudentId, Name, MatrNr, Faculty)Lecturer (LecturerID, Name, Institute, Salary) Faculty (FacultyID, PAYENo, Name, PersonType, Department, Faculty, Institute, TeachingStatus, Salary, CarLotNo, ComputerNo) Write one SQL script to populate the faculty database with the three lecturers below given the following critical information for each lecturer. 1- John Doe is new and so does not have a computer.2- Jack Sprat does not drive a car.3- Win Ling is a visiting professor
- 4.Specify the following queries in SQL on the database schema of figure a.Retrieve the names of all senior students majoring in ‘CS’ (computer science). b Retrieve the names of all courses taught by Professor King in 1998 and 1999. c.For each section taught by Professor King, retrieve the course number, semester, year, and number of students who took the section. d.Retrieve the name and transcript of each senior student (Class = 5) majoring in CS. A transcript includes course name, course number, credit hours, semester, year, and grade for each course completed by the student. e.Retrieve the names and major departments of all straight-A students (students who have a grade of A in all their courses). f.Retrieve the names and major departments of all students who do not have a grade of A in any of their coursesThe physical database can be created using DDL (Data Definition Language) and manipulated using DML (Data Manipulation Language), which enable users to access or manipulate data as organized by the appropriate model.i) Using the CREATE TABLE in any dialect of SQL, show the corresponding SQL tables. Indicate the primary key, foreign keys, column names, constraints etc. ii) Insert (at least) 10 sample rows for each identified table. Student must test their database using at least the following:- Restriction and Projection - Aliases - NULL value handling - Concatenation - Comparison Operator - Logical Operator - Sorting - Function ()Group function & Single Row Function - Joins - Subqueriesand execute the following queries in relational algebra (RA) using the RA interpreter on the COMPANY database schema.List the names of all employees in department 5 who work more than 10 hours per week on the ProductX project. List the names of employees who are directly supervised by Franklin Wong. List the names of employees who work on at least one project in Dallas but the department has no location in Dallas. List the names of employees who work on every project.please answer them in a very clean and clear so I can read it and understand it Write precise and direct query.
- Consider a database with the following schema: Person ( name, age, gender ) name is a keyFrequents ( name, pizzeria ) (name, pizzeria) is a keyEats ( name, pizza ) (name, pizza) is a keyServes ( pizzeria, pizza, price ) (pizzeria, pizza) is a key Write relational algebra/SQL expressions for the following:a. Find the names of all females who eat both mushroom and pepperoni pizza.b. For each person, find all pizzas the person eats that are not served by any pizzeria the personfrequents. Return all such person (name) / pizza pairs.c. Find all pizzerias that are frequented by only females or only males.Part A Create a database called AWESOME and initialize it with the following schema: Suppliers(sid: integer, sname: string, address: string)Parts(pid: integer, pname: string, color: string)Catalog(sid: integer, pid: integer, cost: real) The Catalog relation lists the prices charged for parts by Suppliers. Write the SQL script to create the tables, including implied foreign keys, and populate it with sample data. Sample data should be minimum 4 records each and able to prove the queries in part B are accurate. (ie Query # 4 requires a supplier with a specific name to be included) Part B Write the following queries in SQL: For every supplier that only supplies green parts, print the name of the supplier and the total number of parts that she supplies. For every supplier that supplies a green part and a red part, print the name and price of the most expensive part that she supplies.Part A Create a database called AWESOME and initialize it with the following schema: Suppliers(sid: integer, sname: string, address: string)Parts(pid: integer, pname: string, color: string)Catalog(sid: integer, pid: integer, cost: real) The Catalog relation lists the prices charged for parts by Suppliers. Write the SQL script to create the tables, including implied foreign keys, and populate it with sample data. Sample data should be minimum 4 records each and able to prove the queries in part B are accurate. (ie Query # 4 requires a supplier with a specific name to be included) Part B Write the following queries in SQL: Find the sids of suppliers who supply only red parts. Find the sids of suppliers who supply a red part and a green part. Find the sids of suppliers who supply a red part or a green part. For every supplier that only supplies green parts, print the name of the supplier and the total number of parts that she supplies. For every supplier that supplies a green part and a…
- Part A Create a database called AWESOME and initialize it with the following schema: Suppliers(sid: integer, sname: string, address: string)Parts(pid: integer, pname: string, color: string)Catalog(sid: integer, pid: integer, cost: real) The Catalog relation lists the prices charged for parts by Suppliers. Write the SQL script to create the tables, including implied foreign keys, and populate it with sample data. Sample data should be minimum 4 records each and able to prove the queries in part B are accurate. (ie Query # 4 requires a supplier with a specific name to be included) Part B Write the following queries in SQL: Find the pnames of parts supplied by Acme Widget Suppliers and no one else. Find the sids of suppliers who charge more for some part than the average cost of that part (averaged over all the suppliers who supply that part). For each part, find the sname of the supplier who charges the most for that part. Find the sids of suppliers who supply only red parts. Find the…Part A Create a database called AWESOME and initialize it with the following schema: Suppliers(sid: integer, sname: string, address: string)Parts(pid: integer, pname: string, color: string)Catalog(sid: integer, pid: integer, cost: real) The Catalog relation lists the prices charged for parts by Suppliers. Write the SQL script to create the tables, including implied foreign keys, and populate it with sample data. Sample data should be minimum 4 records each and able to prove the queries in part B are accurate. (ie Query # 4 requires a supplier with a specific name to be included) Part B Write the following queries in SQL: Find the pnames of parts for which there is some supplier. Find the snames of suppliers who supply every part. Find the snames of suppliers who supply every red part. Find the pnames of parts supplied by Acme Widget Suppliers and no one else. Find the sids of suppliers who charge more for some part than the average cost of that part (averaged over all the suppliers…Consider the following relational schema:Student (sid, sname, dept)Enroll (cid, sid, grade, semester)Course (cid, cname, dept, credit)Prereq (cid, pid) Write the following queries in Relational Algebra expression: a) For students who have received an A in a course, return name of students and titleof the course. b) Find name and id of students taken at least one of the prerequisite of CS595course and got an A grade in this prerequisite course.