(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
- Execute the following statements using MYSQL: 1. Insert a row with the values (005, "Your name", , "Your Dept", 50000, 40) 2. Create a trigger (model trigger) to ensure that no employee of salary less than 20000 can be inserted in the database. Show the result for your trigger condition by inserting a new row.The relational schema shown below is part of a hospital database. The primary keys are highlighted in bold. Patient (patientNo, patName, patAddr, DOB)Ward (wardNo, wardName, wardType, noOfBeds)Contains (patientNo, wardNo, admissionDate)Drug (drugNo, drugName, costPerUnit)Prescribed (patientNo, drugNo, unitsPerDay, startDate, finishDate) Formulate the following SQL statements: a) Find the names of all the patients being prescribed ‘Morphine’.b) What is the total cost of Morphine supplied to a patient called ‘John Smith’?c) For each ward that admitted more than 10 patients today, list the ward number, ward type and number of beds in each ward.The relational schema shown below is part of a hospital database. The primary keys are highlighted in bold. Patient (patientNo, patName, patAddr, DOB)Ward (wardNo, wardName, wardType, noOfBeds)Contains (patientNo, wardNo, admissionDate)Drug (drugNo, drugName, costPerUnit)Prescribed (patientNo, drugNo, unitsPerDay, startDate, finishDate) for CONTAINS nad PRESCRIBED table , which one is primary key and how to create table ?
- In Sql These are some database from a set of tables insert into AccountHolder(AccountID, CustomerID, AccountType)values (55003, 115, 'Savings'),(44001, 101, 'Chequing'),(55006, 109, 'Savings'),(44002, 102, 'Chequing'),(44003, 113, 'Chequing'),(55007, 108, 'Savings'),(44004, 103, 'Chequing'),(44005, 110, 'Chequing'),(55005, 112, 'Savings'),(44006, 114, 'Chequing'),(55001, 111, 'Savings'),(44007, 107, 'Chequing'),(44008, 104, 'Chequing'),(55004, 106, 'Savings'),(44009, 105, 'Chequing'),(44010, 113, 'Chequing'),(55002, 107, 'Savings'),(44011, 110, 'Chequing'),(44012, 104, 'Chequing') select * from AccountHolder insert into Branch(LocationID, BranchName, Address, Type, DepositSum, LoanSum)values (1, 'Boulevard Branch', '3268 Wade Boulevard', 'Rural', 171848.88, 37681.72),(2, 'Avenue Branch', '4814 Dare Avenue', 'Rural', 232707.42, 68324.56),(3, 'Street Branch', '208 Ferry Street', 'Commercial', 375010.75, 44665.08),(4, 'Road Branch', '468 Zulauf Road', 'Commercial', 496001.41,…The relational schema shown below is part of a hospital database. The primary and foreign keys are highlighted in bold. Patient (patientNo, patName, patAddr, DOB)Ward (wardNo, wardName, wardType, noOfBeds)Admission (patientNo, wardNo, admissionDate)Drug (drugNo, drugName, costPerUnit)Prescribed (patientNo, drugNo, unitsPerDay, startDate, finishDate) Write SQL queries based on the hospital database given above: 1. Create the above tables together with its constraints. 2. Insert some data into the tables to check that the tables created are correct. No limit on how many rows you want to add. Insert Syntax:insert into table_namevalues (col1_value, col2_value, etc.); 3. List all the patients’ details, alphabetically by name. IF YOU WANT SOME CHALLENGE4. List all the patients admitted today. (Join between Patient and Admission table)Given the Bank database that contains the following tables (primary keys are underlined and foreign keys are preceded with #):Agency(agencyNumber, agencyName, city, assets)Client (clientNumber, firstName, lastName, clientCity)Account(accountNumber, #agencyNumber, #clientNumber, balance)Loan(loanNumber, #agencyNumber, #clientNumber, amount ) 4) Write a PL / SQL block to display the details of clients who have made a loan with an amount more than 5000. This block should display clientNumber, firstName, lastName, client City along with the amount of the loan.
- 3. The following relational schema form a university database which is implemented in a relational database: student (s ID, s_name, semester, year) department(d_ID, d_name, floor) course (c_code, c_title, d_ID, credits) Write down the SQL commands for the following queries: a) Find the titles of all courses from your own CSE department using subquery. b) Show the department names starting with “C" and ending with “g". c) Sort the number of courses for each department in a descending order. d) Insert your own information into the student table.Answer the following prompts 1The InstantRide Management team founded a new team for car maintenance. The new team is responsible for the small maintenance operations for the cars in the InstantRide system. The main idea is to take actions faster and minimize the time spent for the maintenance. Therefore, the Car Maintenance team wants to store MAINTENANCE_TYPE_ID (char(5)) and a MAINTENANCE_TYPE_DESCRIPTION (varchar(30)) in the database. Using MAINTENANCE_TYPE_ID as the PRIMARY KEY, create a new table, MAINTENANCE_TYPES, and send the table description with the column names and types to the Car Maintenance team. 2The Car Maintenance team also wants to store the actual maintenance operations in the database. The team wants to start with a table to store CAR_ID (CHAR(5)), MAINTENANCE_TYPE_ID (CHAR(5)) and MAINTENANCE_DUE (DATE) date for the operation. Create a new table named MAINTENANCES. The PRIMARY_KEY should be the combination of the three fields. The CAR_ID and MAINTENANCE_TYPE_ID…For the following database scheme Employee(empNo,fName.IName.address.DOB.sex,position.deptNo) Department(deptNo.deptName,mgrEmpNo) Project(projNo.projName,deptNo) WorksOn(empNo.projNo.dateWorked,hoursWorked) Write an SQL statement to find all the details of employees who are female
- The aim of assignment 1 is to implement a database schema and execute different types of SQL queries in Oracle SQL developer. Given the following relational schema: Student (studid, FirstName, LastName, Email, phoneNumber, DateofBirth, GPA) Club (clubid, ClubName, #studid) MemberOf (#clubid, #studid, joiningDate ) Activities (actid, actdt, place, durationNbHour) Organize (#actid , #clubid , fee) 1. Write SQL queries to create the following tables according to the below descriptions. Table name: Student studid |Char(9) Primary key FirstName Varchar2(50) NOT NULL LastName Varchar2(50) NOT NULL Email Varchar2(50) NOT NULL, UNIQUE phoneNumber Number(8) NOT NULL, UNIQUE DateofBirth Date NOT NULL GPA Number(1,2) NOT NULL Table name: Club clubID Number(3) Primary key ClubName Varchar2(20)NOT NULL NULL, UNIQUE, NOT Foreign key studid Char(9) Table Name: MemberOf ClubID Number(3) Primary Key, Foreign Key Studid Char(9) Primary Key, Foreign Key joiningDate Date Table Name: Activities Actid…Given the following relation: Book (BookID, Author, ISBN, Title) Write a PL/SQL block of code that performs the following tasks: Read a Book id provided by user at run time and store it in a variable. Fetch the Author and title of the book having the entered id and store them inside two variables Display the fetched book author and title.Question 13 Given the following relation: Book (BookID, Author, ISBN, Title) Write a PL/SQL block of code that performs the following tasks: i. Read a Book id provided by user at run time and store it in a variable. ii. Fetch the Author and title of the book having the entered id and store them inside two variables iii. Display the fetched book author and title.