Question 14Consider the following schema and answer the following questions:Users(userld: integer, userName: varchar, userCity: varchar)Comment(userld: integer, pictureld:; integer, score: integer, commentText: varchar)Picture(pictureld: integer, title: varchar, description: varchar, userld: integer)a Write the following queries in relational algebra.i. Find the username of users who are from 'Muscat'.i. Find the IDs of pictures which scores more than 2000 likes.iii. Find IDs of pictures which descried as landscape.b. Write SQL queries for the following statements.i. Display all the picture's details in the decreasing order of their scores.ii. Count and display the number of pictures posted by each user.iii. Add the given new user's data into the Users table.userlduserNameuserCity2536User2021omMuscatParagraphArial3 (12pt)T T TTT T,lil

Consider the following schema and answer the following questions: Users(userld: integer, userName: varchar, userCity: varchar) Comment(userld: integer, pictureld: integer, score: integer, commentText: varchar) Picture(pictureld: integer, title: varchar, description: varchar, userld: integer) a Write the following queries in relational algebra. i. Find the username of users who are from 'Muscat'. ii. Find the IDs of pictures which scores more than 2000 likes. iii. Find IDs of pictures which descried as landscape.

Consider the following schema and answer the following questions: Users(userld: integer, userName: varchar, userCity: varchar) Comment(userld: integer, pictureld: integer, score: integer, commentText: varchar) Picture(pictureld: integer, title: varchar, description: varchar, userld: integer) a Write the following queries in relational algebra. i. Find the username of users who are from 'Muscat'. ii. Find the IDs of pictures which scores more than 2000 likes. iii. Find IDs of pictures which descried as landscape.

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Q: Given the default schema of a database: Orders 123 Orderld OrderDate ADC OrderNumber 123 Customerld…

A: A Foreign key is a field in a table that is used to reference the Primary key of another table. It…

Q: Consider the following sales relational database schema for sales. tem (ItemNo: integer, itemName…

A: Below is the answer of the above query. I hope this will be helpful for you...

Q: Consider the following relational schema Student (StudentID, SName, Major, level, age) Class…

A: Find the required queries given as below : As per the company guidelines we are supposed to answer…

Q: Please look at this schema. Please convert this into a relational schema (you can give the answer as…

A: Solution- Data Model Diagram to Relational Database Conversion Rules: 1. Each entity in Data Model…

Q: 4. In a company, employees involved in many projects, and each project may have many employees…

A: Please refer below for your reference:

Q: This is my attempt at DBDL statements trying to plan a database in MySQL. Employers: CREATE TABLE…

A: The schema information given above statment is structure and put it into MySQL 8.0 workbench with…

Q: # Question 1 #Using the World database, in the city table, insert a new city for the Tasmania…

A: What is SQL: SQL is a language for interacting with databases. SQL is the standard language for…

Q: Seminar eminar ID Integer eminar Date Date Seminar Time Time ocation Seminar Title Address String…

A: As the customer may or may not attend the seminar or several seminars, the seminar and the customer…

Q: Write a simple PL/SQL function which has the following definition. Refer to the "EMP" below for…

A: PL/SQL which refers to the one it is the purpose of PL/SQL in order to combine database language…

Q: What features do normalization procedures that use functional dependencies have?

A: Functional reliance: Between two characteristics—primary key attributes and non-key attributes…

Q: Consider the following structure of an inventory Oracle database. HUMERC (B) WOWR) VIMOHAR ( S DECL…

A: Neither not we have to select customers not from new york or grade value greater than 100 i.e less…

Q: Relation Students has schema: CREATE TABLE Students ( Banner ID CHAR(9); stuName VARCHAR(40) NOT…

A: To determine whether an insertion into the Students table is legal based on the given schema, we…

Q: Flight-Distance Database FLIGHT (Flight#, Origin, Destination, Mileage) FLIGHT Flight# DL507 DL123…

A: For a table to be in 3rd NF : It should be in 2nd NF and should not have any transitive dependency…

Q: Task

A: Answer Taak 1:- Output:-

Q: The main aim of your project is to create a database schema consists of 3 tables suggested by…

A: We have to create a database schema consisting of 3 tables suggested byyourself and simulate it…

Q: Question 4 (Q4.sql): Use E/R style conversion for subclass DeptID: varchar(20) Departments…

A: The information from the given ER diagram: Departments: Name: nvarchar(50) DeptID: varchar(20)…

Q: Using the sample database, create the Relational Algebra expression to answer the following queries.…

A: CREATE TABLE Continents ( ContID NUMBER(5), Continent VARCHAR2(15), CONSTRAINT…

Q: Exercise 6.2.1: Using the database schema of our running movie example Movies (title, year, length,…

A: Disclaimer: “Since you have posted a question with multiple sub-parts, we will solve the first three…

Q: Consider the following relational schema and answer the following questions. Employee (Employee_Id,…

A: SQL (Structured Query Language) is used for managing and manipulating relational databases. SQL…

Q: Write SQL code for the following design schema of three tables. The tables should have the following…

A: - We need to design three tables with the requirements of constraints as provided.

Q: • Students(stulD, lastName, firstName, major, credits) • Faculty (facID, name, deptName, rank) •…

A: The original query attempts to retrieve the class numbers of all classes taught by a faculty member…

Question

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

To be done

Answer a.i.

Answer a.ii

Answer a.iii

Note:-

Trending now

This is a popular solution!

Step by step

Solved in 5 steps

SEE SOLUTION Check out a sample Q&A here

Similar questions

Consider the following table in a relational database.Last Name Rank Room ShiftSmith Manager 234 MorningJones Custodian 33 AfternoonSmith Custodian 33 EveningDoe Clerical 222 MorningAccording to the data shown in the table, which of the following could be candidate keys of the table?a) {Last Name}b) {Room}c) {Shift}d) {Rank, Room}e) {Room, Shift}
Q1: Consider the following relations for a Guest Room reservation application database. Room (room_id, room_ availability, booking date. Cust id. booking details) Customer(Cust id. CNIC, E name. L name, Address, Contact number, MembershipNo.) Assume that each Hotel of a city has different number of rooms where each room can be booked by any customer at any time subject to its availability. If we apply a natural join on the relations Room and Customer in this database, what does the resulting relation schema look like? Explain the result of this operation. Show the Functional Dependencies in this resulting relation. Is it in 2NF? Is it in 3NF? Why or why not? (State assumptions, if you make any.)
There are three tables in this database (see image). Write MYSQL code for: (1) Create a trigger “insert_inventory” on table “Inventory”. The trigger is fired after a row is inserted in table “Inventory”. After a row is inserted in table “inventory”, the “itemid”, the insertion time, and the action is inserted in table “Inventory_history”. The action is set to ‘add an item’. The oldprice is set to null. Test your trigger by inserting a row into Inventory and displaying the contents of Inventory_history. (2) Create a trigger “change_quantity” on table “Transaction”. The trigger is fired after a row is inserted in table “Transaction”. After a row is inserted in table “Transaction”, update the “quantity” in table “Inventory”. For example, if 3 iWatch are sold, then the quantity of iWatch in table “Inventory” is decreased by 3. Test your trigger by inserting a row into Transaction and displaying the contents of the relevant row in Inventory. (3) Create a trigger “change_price” on table…
SQL. Write true or false.
I am having some trouble with this for an assignment in Database. I am trying to create some queries for this homework: Assignment 5: Data Definition language and Transaction in MySQL This is what I am currently working on: On June 3, 2019, customer ‘10010’ makes a payment of $100 in cash. The payment ID is 3428. The query as it is as of this moment: SELECT PAYMENTINSERT INTO PAYMENT (PMT_ID,PMT_DATE,CUS_CODE,PMT_AMT,PMT_TYPE,PMT_DETAILS)VALUES(3428,6-3-2019,10010,100.00,cash,account),UPDATE CUSTOMERSET CUS_BALANCE = CUS_BALANCE + 100WHERE CUS_CODE=10010,COMMIT 2. On May 11, 2019, customer ‘10012’ makes a credit purchase of one unit of product ‘11QER/31’ with a unit price of $110.00; the invoice total is $118.80. The invoice number is 10983, and this invoice has only one product line. [note: no payment has been made here] The Query as of now: BEGIN TRANSACTION; INSERT INTO VOICE VALUES (10983, 10012, ’5-11-2019’), INSERT INTO LINE VALUES (10983, 1, ‘11QER/31’, 1, 110.00), UPDATE…
q20- Choose ALL that apply.
3. Consider the following schema. where the primary keys are given. Give an expression in SQL for each of the queries. Person ( FirstName:String, LastName:String, Age, Email: varchar) FacebookUser ( FbUserlID: Integer, FbUserName:String, Email:varchar, Num_of_friend: integer, Num_of_pic: integer) WhatsAppUser (WhatsAppUserlD: Integer, FBUserlID: Integer, Cell_num: varchar, WhatsAppUserName:String , No_Of_Groups: Integer) Now, Give an expression in SQL for each of the queries. a) Find the Facebook user who shares the least number of pictures. b) Find the WhatsApp users who are GrameenPhone users (GrameenPhone numbers start with 017.... Or 013....) c) Show the details of your own Facebook account searching by your valid DIU Email. d) List the full names of Facebook users having gmail addresses in dictionary order based upon their names. e) Show all the details of those Facebook users whose number of friends is more than or equal to 500 but less than or equal to1000.
Task 1: The 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 MAINTENACE_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.
I NEED HELP WITH THIS QUESTION FOR MY DATABASE MANAGEMENT CLASS FOR SQL DEVELOPER 5. Now compute Average GPA in each class. Display class_code, Class_GPA. Assume all courses are 3 credit courses. A general formula for GPA would be sum(gradepoints x Hrs)/sum(Hrs). Here you can just take an average of gradepoints as the credit hours are same for all courses.
Consider the following database composed of two tables. PLAY PLAY_CODE PLAY_NAME DIR_NUM 1001 Cat On a Cold, Bare Roof 102 1002 Hold the Mayo, Pass the Bread 101 1003 I Never Promised You Coffee 102 1004 Silly Putty Goes To Washington 100 1005 See No Sound, Hear No Sight 101 1006 Starstruck in Biloxi 103 1007 Stranger In Parrot Ice 101 DIRECTOR DIR_NUM DIR_FNAME DIR_LNAME DIR_DOB 100 Sean Broadway 1/12/65 101 Josh Hollywoody 11/18/53 102 Will Goofy 6/21/62 1. Do the tables exhibit Entity Integrity? Why? 2. Do the tables exhibit Referential Integrity? Why? 3. Is the relationship between the two tables strong or weak? Explain why. Please label your answers (for no. 1, 2, or 3) clearly.