Question: DBMS Question 3. (5*1) = 5 Consider the following schema. where the primary keys are given. Give an expression in SQL for each of the

DBMS Question 3. (5*1) = 5 Consider the following schema. where

DBMS Question

3. (5*1) = 5 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 (FbUserID: Integer, FbUserName:String, Email:varchar, Num_of_friend: integer, Num_of_pic: integer) WhatsApp User (WhatsAppUserID: Integer, FBUserID: 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 to 1000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

1. Assume the following table- Degree (degcode, name, subject) Candidate (seatno, degcode, name, semester, month, year, result) Marks (seatno, degcode, semester, month, year, papcode, marks) [degcode...

You have been provided with the description of a programming language, J, intended for scripting applications. Its syntax is similar to a cut-down version of Java in that it consists of function...

1 . Which of the following is NOT a valid data type in SQL Server? ( a ) int ( b ) varchar ( c ) decimal ( d ) blob 2 . What is the purpose of a primary key? ( a ) To enforce data integrity ( b ) To...

1 . ( 1 0 points ) ( a ) What is a 1 - tier architecture in DBMS , and what are its limitations ? ( b ) Describe a 2 - tier architecture in DBMS and its main advantage. ( c ) What is a 3 - tier...

I need help for SQL DDL statements. Please do not use CHATGPT. Thank you in advance Question 1 . Consider the following schema given in Figure 1 where the underlined attributes are primary keys and...

database management system, pdf is attached COURSEWORK SECOND SEMESTER 2019/2020 SESSION (A192) COURSE CODE & NAME : BKAS3053 DATABASE MANAGEMENT SYSTEM LECTURER'S NAME : ASSOC. PROF. TS. DR. AIDI...

True-False Questions 1. Normalizing accounting data refers primarily to eliminating errors and outliers, thus creating ?normal data.? 2. An important reason for normalizing data is to eliminate data...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

database management system COURSEWORK SECOND SEMESTER 2019/2020 SESSION (A192) COURSE CODE & NAME : BKAS3053 DATABASE MANAGEMENT SYSTEM LECTURER'S NAME : ASSOC. PROF. TS. DR. AIDI AHMI DR. MOHD...

For how to: https://www.freecodecamp.org/news/how-to-install-mysql-workbench-on-windows/ Take a screen shots of your installation and paste here Watch this tutorial Section on how to use MYSQL work...

1. What types of supply chain risks does Zoran face? 2. What steps can Zoran take to minimize the risks it faces? Zoran Corporation is a designer of the chips that go into many of the electronic...

Under the indirect method, how is the net cash provided by operating activities determined in a companys statement of cash flows?

answer this Multiple Choice Question The amount of money paid into a company by its owners is referred to as: O investment in common stock O retained earnings O contributed capital O owners' surplus

Thompson Company had $870,000 of bonds outstanding. Each $1,000 bond can be converted into 29 shares of Thompson Company $15 par stock. On May 19, 2020, when the bond carrying value was $830,100,...

KEY QUESTION Suppose the price level and value of the dollar in year 1 are 1 and $1, respectively. If the price level rises to 1.25 in year 2, what is the new value of the dollar? If, instead, the...

What would happen to the stated sizes of Federal budget deficits or surpluses if the current annual additions or subtractions from the Social Security trust fund were excluded?

Which two of the following financial institutions offer checkable deposits included within the M 1 money supply: mutual fund companies; insurance companies; commercial banks; securities firms; thrift...