1. Design and draw an ER diagram for database.2. Write DDL statements to create the tables.3. Insert at least 3 records (row) in each table. |4.Select all those professors who age in the range 30 to 40 and don'thave any rank.5.Count the number of different professor names.6.List all professors whose name begins with 'A' or 'L' and age7. Large than 30.8.Find the names of professors supervising graduate students that age>22.9. Find the names of professors who have works in at least one project.10. Change the any name of professor to 'Ali'.11. Select all information about professor whose name is 'Ali'12. Delete the record for the professor whose name is 'Ali'.13. Find the names of graduate students who have works on projectswith budget >300, and list in the order of budget.14. create view that view names of professors and name of project15. Find the name and the age of the youngest professors16. Find all information of projects who have managed by eachprofessor17. Write a query to retrieve name of professor, department name andproject, for all projects whose budget is greater than 400.

As per our company guidelines, only one question will be answered. So, please repost the remaining…

Answered: Design and draw an ER diagram for…

Engineering

Computer Science

Design and draw an ER diagram for database.

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter2: Database Design Fundamentals

Section: Chapter Questions

Problem 11RQ

See similar textbooks

Similar questions

An EMPLOYEES table was added to the JustLee Books database to track employee information. Display a list of each employee’s name, job title, and manager’s name. Use column aliases to clearly identify employee and manager name values. Include all employees in the list and sort by manager name.
How is the processing of SQL DDL statements (such as CREATE TABLE) different from the processing required by DML statements?
The following tables provide a very small portion of the data that will be kept in the database. These data need to be inserted into the database for testing purposes. Write the INSERT commands necessary to place the following data in the tables that were created in Problem 65. RENTAL RENT_NUM RENT_DATE MEM_NUM 1001 01-MAR-13 103 1002 01-MAR-13 105 1003 02-MAR-13 102 1004 02-MAR-13 110 1005 02-MAR-13 111 1006 02-MAR-13 107 1007 02-MAR-13 104 1008 03-MAR-13 105 1009 03-MAR-13 111 VIDEO VID_NUM VID_INDATE MOVIE_NUM 54321 18-JUN-12 1234 54324 18-JUN-12 1234 54325 18-JUN-12 1234 34341 22-JAN-11 1235 34342 22-JAN-11 1235 34366 02-MAR-13 1236 34367 02-MAR-13 1236 34368 02-MAR-13 1236 34369 02-MAR-13 1236 44392 21-OCT-12 1237 44397 21-OCT-12 1237 59237 14-FEB-13 1237 61388 25-JAN-11 1239 61353 28-JAN-10 1245 61354 28-JAN-10 1245 61367 30-JUL-12 1246 61369 30-JUL-12 1246
When working with a relational database, a select operation may be used to reduce the amount of space used by a table by removing columns that meet certain requirements.Is this the right answer or the wrong answer?
A database at a college must support the following requirements: a. For a department, store its number and name. b. For an advisor, store his or her number, last name, first name, and the department number to which the advisor is assigned. c. For a course, store its code and description (for example, DBA210, SQL Programming). d. For a student, store his or her number, first name, and last name. For each course the student takes, store the course code, course description, and grade earned. Also, store the number and name of the student's advisor. Assume that an advisor might advise any number of students but that each student has just one advisor. Design the database for the preceding set of requirements. Determine any functional dependencies. List the tables, columns, and relationships. In addition, represent your design with an E-R diagram.
Write 10 SELECT statements for the database you have implemented.i. 3 of them should use minimum 2 tables.ii. 4 of them should use minimum 3 tables.iii. 3 of them should use minimum 4 tables.
Write a query to display the first name, last name, and email address of employees hired from January 1, 2005, to December 31, 2014. Sort the output by last name and then by first name. Write the answer to each query and the result of the query (screen capture). You should submit all design work, program documentation, and relevant sample screen shots of your implementation. A script file with all database creation and table populating is required.
In a relational database, a select operation is used to minimise the size of a table by eliminating columns that do not fulfil certain constraints.Is this statement true or false?
Create ERD for Real-estate database: There are Many Cities in each State There are Many Zip Codes in each City Many Houses belong to each ZipCode Each House can be one of HouseTypes ( Town House, Residential, Condo, Single Family) Each House can be Sold multiple times. ( entity Sales
FirstName EID Name LastName Employee Birthdate TEL Age) n work date ID Name m Project Rate In the physical design phase, which SQL statement is the most correct one to create the Employee table in the above E-R diagram for the MySQL database? create table Employee (EID varchar(10) primary key, FirstName varchar(50), LastName varchar(50), Age int, Birthday date, TEL varchar(20)); create table Employee (EID varchar(10) primary key, FirstName varchar(50), LastName varchar(50), Birthday date); create table Employee (EID varchar(10) primary key, Name varchar(50), TEL varchar(20)); create table Employee (EID varchar(10) primary key, Name varchar(50), Age int, Birthday date);
Subject: Database Write the SQL statement for the following tasks. 1. Create a database for a library name MY_LIBRARY 2. Based on the given details, write the statements to create the following tables (include constraints):
Book (BookID, Price, Year, Author, Subject) BorrowLog (BID, BookID, CustomerID, DateTime) Customer (CustomerID, CustomerName, Address, City) Write the DDL script to create “smallLibrary” database with the given three tables. Please include the primary key and referential constraints for the foreign key.

SEE MORE QUESTIONS

Recommended textbooks for you

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Programming Logic & Design Comprehensive

Computer Science

ISBN:

9781337669405

Author:

FARRELL

Publisher:

Cengage

CMPTR

Computer Science

ISBN:

9781337681872

Author:

PINARD

Publisher:

Cengage

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Programming Logic & Design Comprehensive

Computer Science

ISBN:

9781337669405

Author:

FARRELL

Publisher:

Cengage

CMPTR

Computer Science