Question

Databse Schema: BUILDING (BuildingNo, BuildingName) LAB (RoomNo, Capacity, BuildingNo) STAFF (StaffNo, StaffName, Email, Phone) SOFTWARE (SoftwareID,...

Databse Schema:

BUILDING (BuildingNo, BuildingName)

LAB (RoomNo, Capacity, BuildingNo)

STAFF (StaffNo, StaffName, Email, Phone)

SOFTWARE (SoftwareID, SoftwareName, Version, MediaLocation)

REQUEST (RequestID, StaffNo, SoftwareID, RoomNo, RequestDate, TeachingPeriod, Progress)

Provide relational algebra queries to find the following information:

List the names of software requested for labs in the Law building, requested by staff member S2019876, or both.

List all the labs in the Law building, and the names of software requested for each of them (if any).

Engineering   Computer-Science   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

If you have any doubts, please give me comment...

List the names of software requested for labs in the Law building, requested by staff member S2019876, or both.

List all the labs in the Law building, and the names of software requested for each of them (if any).

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
You are working with a database that stores information about suppliers, parts and projects. The Supply...
You are working with a database that stores information about suppliers, parts and projects. The Supply relation records instances of a Supplier supplying a Part for a Project. The schema for the database used in this question is as follows: (note that primary keys are shown underlined, foreign keys in bold). SUPPLIER (SNo, SupplierName, City) PART (PNo, PartName, Weight) PROJECT (JobNo, JobName, Country) SUPPLY (SNo, PNo, JobNo, Quantity) Provide relational algebra (NOT SQL) queries to find the following information. Each...
You are asked to design a database to support a Instant Recruitment System of casual staff...
You are asked to design a database to support a Instant Recruitment System of casual staff for a school. The major business requirements are summarised below in the Mini Case: An Instant Recruitment System. You are asked to develop a detailed Entity-Relationship model for this mini case. Your ER model should consist of a detailed ER diagram integrated with itemised discussions on the features of the entities and relationships and all the assumptions you made where applicable. The ER diagram...
Write the query that lists the PID, FirstName, LastName, MajorCode, and MajorName of every student. Write...
Write the query that lists the PID, FirstName, LastName, MajorCode, and MajorName of every student. Write the query that lists the PID, FirstName, LastName, MajorCode, and MajorName of every student majoring in a discipline with the word 'undecided' in the MajorName field. DO NOT LOOK UP THE Majors with undecided in their name and then filter on the MajorCodes!!! We must write queries as if we cannot see the data in them. All we know is the metadata and any...
Lab 5 Queries with Multiple Tables In this lab, we do queries more than one table....
Lab 5 Queries with Multiple Tables In this lab, we do queries more than one table. SQL provides two different techniques for querying data from multiple tables: • The SQL subquery • The SQL join As you will learn, although both work with multiple tables, they are used for slightly different purposes. We used WMCRM database which is what we created in Lab 4. Here is the summary of the database schema (where schema is used in its meaning of...
Acid/Base Chemistry Portland Community College Staff* Version 42-0137-00-01 Lab Report Assistant                          &n
Acid/Base Chemistry Portland Community College Staff* Version 42-0137-00-01 Lab Report Assistant                                                                                             This document is not meant to be a substitute for a formal laboratory report. The Lab Report Assistant is simply a summary of the experiment’s questions, diagrams if needed, and data tables that should be addressed in a formal lab report. The intent is to facilitate students’ writing of lab reports by providing this information in an editable file which can be sent to an instructor. Observations                                                                                                            In columns...
Heinz Children’s Health is a small pediatric practice serving the health- care needs of children in...
Heinz Children’s Health is a small pediatric practice serving the health- care needs of children in a small, rural community. Twenty-five years ago, Dr. Helen Heinz founded the practice, which now includes two physician assistants, two registered nurses, a home health nurse, an office manager, and a receptionist. The practice has always used paper records, but when Dr. Heinz learns that, under the American Recovery and Reinvestment Act (ARRA) of 2009, the Centers for Medicare & Medicaid Services is offeringsignificant...
You are a database consultant with Ace Software, Inc., and have been assigned to develop a...
You are a database consultant with Ace Software, Inc., and have been assigned to develop a database for the Mom and Pop Johnson video store in town. Mom and Pop have been keeping their records of videos and DVDs purchased from distributors and rented to customers in stacks of invoices and piles of rental forms for years. They have finally decided to automate their record keeping with a relational database. You sit down with Mom and Pop to discuss their...
1) In 2003, Motorola released a cell phone, the RAZR, that was a breakthrough in design...
1) In 2003, Motorola released a cell phone, the RAZR, that was a breakthrough in design and major hit with customers. The engineers, designers, and marketers involved came from all over the company. They made decisions independently, including developing the project objectives, the project budget, the project schedule and assigning tasks. The project was finished ahead of schedule and under budget. A. This demonstrates that teams must contain mostly creative professionals to succeed B. This shows the value of autonomy...
PM301 ASSESSMENT 2 S118 Case Study: The Case of the Never Ending Scope Creep In 1999,...
PM301 ASSESSMENT 2 S118 Case Study: The Case of the Never Ending Scope Creep In 1999, the XY Department of the Federal Government reviewed its Year 2000 Date Turnover Computer Risks and found that its outdated computer systems for managing public clients needed replacing. A business case was prepared for funding the replacement while at the same time implementing some improvements. The total budget requested was $2.3 million. In view of a shortage of funds around at the time, government...
Directions: Develop an E-R (or EER depending upon need) Diagram. List all assumptions. Show the version...
Directions: Develop an E-R (or EER depending upon need) Diagram. List all assumptions. Show the version 1 (entities and data only) and version 3 (entities, attributes and relationships with cardinalities and participation constraints). 20 points of the grade will be based on evaluating your assumptions - you must give a detailed list of your assumptions identifying anchor concepts, data associated with the anchor and data that has more than one anchor participating in it. Remember, we are not talking out...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT