EMP: NUMBER (4) EMPNO VARCHAR2 (10) ΕΝΑΜΕ VARCHAR2 (9) JOB NUMBER (4) MGR HIREDATE DATE NUMBER (7, 2) SAL NUMBER (7, 2) СOMM NUMBER (2) DE PTNΟ DEPT: NUMBER (2) DE PTNΟ VARCHAR2 (14) DNAME VARCHAR2 (13) LOC

If an employee can work for only one department and a department can have many employees (one to many relationship). Which answer the relationship table "work" that has the best values to describe the relationship between employee and department? The employee table has two columns (eid, name) with records ('E1','A'), ('E2','B'), ('E3','C'). The department table has two columns (did, name) with records ('D1','X'), ('D2','Y'), ('D3', 'Z'). work(eid, did) with values ('E1','D1'), ('E1','D2'), ('E2,'D2'). work(eid, did) with values ('E1','D1'), ('E2','D2'), ('E3,'D2'). work(eid, did) with values ('E1','D1'), ('E2','D2'), ('E2,'D3'). work(eid, did) with values ('E1','D1'), ('E2','D2'), ('E3,'D3').

Please answer 2 and 3

What exactly do we mean when we say that the criteria must be "full and logically organized"?

Write SQL queries for the database and questions below. user (email, password, name, date_of_birth, address, type) celebrity (email, website, kind) blurt (blurtid, email, text, location, time) foreign key(email) references user(email) hobby (email, hobby) follow (follower,followee) vendor (id, name) vendor_ambassador (vendorid, email) topic (id, description) vendor_topics (vendorid,topicid) blurt_analysis (email,blurtid,topicid,confidence,sentiment) advertisement (id, content, vendorid) user_ad (email,adid)   Question 1: Write the following query in SQL: “Find (all) the celebrities with the most followers.” You should print the name of each celebrity and the corresponding number of followers. Note there may be more than one celebrity with the same number of followers. Question 2: Translate the following query into one English sentence: SELECT NAME FROM user WHERE email IN (SELECT email FROM celebrity WHERE email NOT IN (SELECT email FROM blurt))

What exactly do we mean when we say that the criteria must be "full and logically organized"?

Discuss when you would use total specialization and when you would use partial specialization.

Do all the sub parts

WHAT IS THE RELATIONSHIP THIS TABLE ZERO TO MANY OPTIONAL ? ONE TO MANY ? ONE MANDATORY ? ONE TO ONE ? ONE ? ZERO TO ONE ? MANY ? MANY TO MANY ? ONE OPTIONAL TO MANY OPTIONAL ? ONE MANDATORY TO MANY OPTIONAL ?    MANY)

The questions in this group refer to the following three relations: SALESPERSON (Name, Age, Salary) ORDER (Number, Customer Name, Salesperson Name, Amount) CUSTOMER (Name, City, Industry Type) SALESPERSON Name Age Salary Abel 63 120,000 Baker 38 42,000 Jones 26 36,000 Murphy 42 50,000 Zenith 59 118,000 Kobad 27 34,000 ORDER Number CustName SalespersonName Amount 100 Abernathy Construction Zenith 560 200 Abernathy Construction Jones 1800 300 Manchester Lumber Abel 480 400 Amalgamated Housing Abel 2500 500 Abernathy Construction Murphy 6000 600 Tri-City Builders Abel 700 700 Manchester Lumber Jones 150 CUSTOMER Name City Industry Type Abernathy Construction Willow B Manchester Lumber Manchester F Tri-City Builders Memphis B Amalgamated Housing Memphis B Use the data in those tables and show the SQL…