Given the following ERD for a Project Management Application-ManagerigLastnameFirst_nameSkal nameManagetSkilsSkill payManagesHas木木ProjectWorks On本EmployeeEmp ldProject_nameProject costEmp frst_nameEmp start_date2.1) Identify (write down) all relationships and their cardinality and write the corresponding businessrules.2.2) Show the relational schema for the database. Make sure to clearly indicate primary keys andforeign keys (be careful on this part, FK's need to Support the Cardinality you listed in Q2.1).木

Answered: Image /qna-images/answer/cffde84d-79f2-4c09-94a3-cc369ab1cc71.jpg

Answered: 2.1) Identify (write down) all…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Consider the following database schema designed to store information about Books, and Chapters. Book (BookID, BookTitle, Price) BookChapter (ChapterID, BookID, ChapterTitle, NoPages) Write the following queries in SQL. 1. Display BookID of all books with price less than the average price of all books. 2. Display ChapterID, BookID, ChapterTitle of all chapters that include the word ‘Database’ in the ChapterTitle.
Please draw an relational ERD with multiplicities and all the attributes based on following description: ( Please identify the primary key in each entity.) An Adult Education Department runs various courses during the daytime and evenings, and at different times of the year. For example, ‘Spanish level 1’ is offered on Monday mornings, Monday evenings or Wednesday evenings, and runs over 25 weeks from October to March. On the other hand, ‘Introduction to Digging Up Your Ancestors’ only runs for 8 weeks, but is offered on Tuesday or Wednesday evenings from October to December, January to March, and April to June, with an optional field week in August. There is always a maximum number of places for each course offering, which is dependent on the individual teacher. For example, ‘Spanish level 1’ on Monday evenings may be limited to 20 places, but on Wednesday evenings the limit may be 25. Each course offering is only taken by one teacher, however teacher may take…
Consider the follow relations’ schemas to answer the following questions: Student (sid, name, level, address) Book(bid, title, author) BorrowedBook(sid, bid, date) 1) Assume that, there are 10,000 Student records stored on 1,000 pages/blocks, 50,000 Book records stored on 5,000 pages, 300,000 BorrowedBook records stored on 15,000 pages, and there are 500 different authors. Find out what is the record size for each of the previous relation?, and what is the blocking factor for each relation?
Which one is correct * Consider the following ER diagram illustrating the relationship of customers and banks. DateActCreated BName BankID Cname Bank Account Customer NID Select from among the following candidates for relations, if the above ER is mapped into a relational model. 1-Customer(NID(pk).CName) 2-Account(DateAccCreated(pk).BName,CName) 3-Bank(BanklD(pk),NID.BName) 4-Bank(BankID(pk).BName) 5-Account(BankID(pk), NID (pk),BName, DateAccCreated) O 1,4 and 5 O 1,2 and 4 1,3 and 5 O 1,2 and 3
Convert the preceding ER diagram into a relational DB schema. (I want you to do this yourself, not using automated tools. You can use ERDPlus to construct the relational schema yourself, or you can do it yourself on paper and take a picture.) Indicate all primary keys correctly. Be sure to include arrows for foreign key relationships. Also make sure that all attributes in a single relation have different names. ER Diagram (DeviceName) Brand Model TicketNum DEVICE REPAIR TICKET Exhibits Nickname Assigned To PROBLEM TechID REPAIR TECHNICIAN Expert At Description Name PhoneExt Level
Explain what "high cohesion" means.
Complete a database design for both the Invoice_printed and Real Estate Agent Listings problems / cases. Display your normalized tables as as demonstrated in the following format: TABLENAME(Field 1 (pk), Field 2, Field 3........)
I need help with the following. Use the schema as reference. So can someone answer this using relational algebra?
I'm having trouble with this question with my data modeling class. " Scenario: Jonny is appointed as an intern position, which might lead to a junior database architect role in TechTrend Corporation (TTC). Jonny is assigned to redesign two legacy tables related to "Suppliers," to be normalization compliant. The following business rules are provided. Business Rules: 1. Suppliers can be local or national, thus can have multiple locations. 2. Any location can supply items to TechTrend. 3. Any location manager can have a separate pricing deal with TechTrend, based on production process specific to that location and localization efficiency. 4. Each location has a contact person assigned to TechTrend. 5. Traditionally, TechTrend dealt with a singular location, at the most two. With rapid growth in business, the TTC officials are finding better leverage possibilities to negotiate beneficial terms with suppliers in multiple locations. 6. The DB administrator has specifically requested Johnny…
Answer questions 2.1 to 2.4 based on the following schema. Note that primary keys are in BOLD. Note also that attributes with the same name in different tables are foreign keys. For example, doctorID in the Treatment table is a foreign key that refers to the Doctor table. Doctor(doctorId:integer, specialtyID:integer, firstName:varchar(20), lastName:varchar(20), salary:numeric(11,2)) Specialty(specialtyID:integer, specialtyName:varchar(20), specialtyCost:numeric(11,2)) Treatment(doctorId:integer, patientSSN:integer, dateTreated:date, costOfTreatment:numeric(11,2)) Patient(patientSSN:integer, firstName:varchar(20), lastName:varchar(20), street:varchar(30), city:varchar(15), state:char(2),zipCode:integer(5)) 2.3) Write an SQL statement to increase the cost of all Specialty treatment by 2.5% 2.4) Write a SQL statement to delete all treatment rows that were done before 2015 and cost less than $500. 2.5) Write an SQL statement to select all Specialties where the specialtytName has a null…
4) List all candidate keys of the books relation. 5) List all of the candidate keys of the publishes relation. 6) List all of the superkeys of the publishes relation. 7) Are there any attributes in considered logically non-atomic? Briefly explain why or why not. 8) Assuming tuple (4,83,200,1990) into the publishes table failed. Why did this happen? What database principle was violated?
Following tables support the database of a shopping store. The schema contains four tables i.e.Customer, Product, Order and Order Product. Table details including attributes, primary keys(underline) and foreign keys (bold) are also shown below:CUSTOMER(CustID, CustName, CustEmail, CustPhone, CustCNIC)PRODUCT(ProdID, ProdName, ProdPrice)ORDER(OrderID, OrderDate, OrderPrice, CustID)ORDER_PRODUCT(OPID, ProdID, OrderID)

Recommended textbooks for you

Database System Concepts

Computer Science

ISBN:

9780078022159

Author:

Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:

McGraw-Hill Education

Starting Out with Python (4th Edition)

Computer Science

ISBN:

9780134444321

Author:

Tony Gaddis

Publisher:

PEARSON

Digital Fundamentals (11th Edition)

Computer Science

ISBN:

9780132737968

Author:

Thomas L. Floyd

Publisher:

PEARSON

Database System Concepts

Computer Science

ISBN:

9780078022159

Author:

Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:

McGraw-Hill Education

Starting Out with Python (4th Edition)

Computer Science

ISBN:

9780134444321

Author:

Tony Gaddis

Publisher:

PEARSON

Digital Fundamentals (11th Edition)

Computer Science

ISBN:

9780132737968

Author:

Thomas L. Floyd

Publisher:

PEARSON

C How to Program (8th Edition)

Computer Science

ISBN:

9780133976892

Author:

Paul J. Deitel, Harvey Deitel

Publisher:

PEARSON

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781337627900

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Programmable Logic Controllers

Computer Science

ISBN:

9780073373843

Author:

Frank D. Petruzella

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS