The figure below shows an ER schema for a university database.Map this ER schema into a relational schema by using the mappingalgorithm discussed in the class. Specify all primary keys andforeign kevs, List the final relational database base schema. Pleaseshow your work.COfficeRankOfficeNameNameIPhoneCOLLEGEDEANINSTRUCTOR(O,N)CStartDate(O,N)CHAIRADMINSNameLNameEMPLOYSldName(O,N)AddrPhoneMajorDCodeDEPTHASSTUDENTDOffice(O,N)DPhone(O,N)(O,N)GradeHESOFFERSTAKES(5,N)COURSESECSSECTIONCredits(O,N)SemCDescTimeYearBldgFgure aram for a UNIVERSITY databaseAn ER diagram for a UNIVERSITY database schema.

Since the question refers to a mapping algorithm which is not described in the question we are going…

Answered: The figure below shows an ER schema for…

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

Normalization works through a series of stages called normal forms. For most purposes in business database design, the normalization process. stages are as high as you need to go in five two four three
Task 1:Create a database Entity and Relationship Diagram (ERD) for the following application:Please include answer with detailed explanationKhair Application: The Application idea: It is a mobile application called (Khair) to help people. This assistance is moral, material. This assistance is also provided by good people in our community. Example to understand the Application idea more: For example, a person urgently needs a medical chair or bed and does not have the ability to purchase what he needs. The medical chair or bed is requested through the application, and whoever has what he requests initiates the request through the application’s messages and determines the meeting place. Application models (page): Login included: login registration login included: user name password New registration included: name E-mail Password phone number date National Identification Number Home page included: Request - applicant name - address - send message Messages list form included: list of…
Generate the table creation DDL for the schema. Consider the keysprimary and foreign.
Don't copy from anywhere. Please give answer of it
How many of the relations in Johnny's logical database design have a composite primary key?
The following three tables make up a simple reservation system for a small campground. The database should allow for a camper to make multiple reservations for future dates and for a camping spot to have several reservations for upcoming visits. Table: Camper CAMPER_NUMBER 1000 1001 1002 1003 CAMPER_LAST_NAME Jones Schmidt Williams Cooper CAMPER_FIRST_NAME Jamie Pat Clifford Amanda CAMPER_ADDRESS 1278 Essex Pl 4954 Spangled Way 956 Segull Lane P. O. Box 998877 CAMPER_CITY Birmingham El Paso Portland Portsmouth CAMPER_STATE AL TX ME OH CAMPER_ZIP_CODE 45251 79919 4108 45662 CAMPER_DRIVERS_LICENSE JJ998743-98 87632434 WIL885123 765A876B897 CAMPER_EMAIL jjones@somewhere.com patwonderfu34l@nowhere.net williams98342@foomail.com coopera@nowhere.net Table: Spot SPOT_NUMBER 101 102 103 104 SPOT_NAME The Pines The Glade Teardrop Spot Tent In Trees…
A hospital would like to set up a database recording which registered nurse looked after which patient etc. Each registered nurse has a unique nurse ID, and each patient has a unique patient ID, and the following attributes are found for nurses, and patients in the first round of design: NURSE: nurselD, suname, first name, birthdate, dept-code, sex, salary-level PATIENT: patientlD, surname, first name, birthdate, wardlD, sex, admission_date, discharge_date A recent duty list shows the patients that were cared by each nurse in past 2 months, see below for some samples:
Structured Query Language (SQL) is a language widely used in industry to create, update and query data in relational databases. You are required to write the SQL code. Q.6.1 The below sample data in the third normal form was provided by a database designer. Answer the below questions using this data. Table: LawFirm Primary key: LawFirmID (auto number) All fields are mandatory LawFirmID Name Yearlncorporated 1 Ze Boss Attorneys 2011 2 Lawyers for the Win 2018 3 Court Rulez 2019 Table: Lawyer Primary key: LawyerlD Foreign key: LawFirmID LawyerID LawFirmlD Surname Name Age Bianchi Anna 45 7 2 Modise Dikeledi 57 8 2 Ferreira Piet 34 3 Nkosi Jabulani 28 Q.6.1.1 Write a SQL statement to create the table Lawyer. Hint: The sample data should give you an indication of the data types you should use. Q.6.1.2 Write a SQL statement that will calculate the average age of all the lawyers that are at least 40 years old. Q.6.1.3 Write a SQL statement to insert the below row into table LawFirm.
Database Principle and Application - 10 ========================== There is a Company Database that manages the data of employee, department and project. The relational schemas are as follows: EMPLOYEE (Fname, Lname, Employee_id, Gender, Salary, DNO). The attribute means: First name, Last name, employee id, gender, salary, the department number in which the employee works. Each employee has a unique employee id, and can join in projects that in different department. DEPARTMENT (DNO, Dname, Manager_id, Dlocation). The attribute means: Department number, department name, department manager id, department location. The department manager is a type of the employee, thus the Manager_id is a foreign key that references the Employee_id in EMPLOYEE table. PROJECT (Project_NO, Pname, DNO). The attribute means: project number, project name, department number of the department that the project belongs to. Part of the data in the relations are as follows： Table1 EMPLOYEE Fname Lname…
Question A city college would like to maintain their academic information in a MySql database system. The following are the interested information: Courses: Catalog # (M170 for instance) Credit Hours; Name of the Course (Database Design Fundamentals for instance) Course Descriptions Prerequisite Components (Lecture, or Laboratory for instance) Classes: Class # Class Name (usually the course name, M 170 for instance) Start Date End Date Meeting time (9:30 am ~ 12:15 pm, for instance) Days in a week (Monday) Term (Spring 2018, for instance) Location (TIE Building for instance) Room (UB 301, for instance) Instructor Online status (online, or in-person) Faculty: Employee Id (001880301, for instance) First Name Last Name Title (professor, for instance) Email Phone Office Location (TIE building, for instance) Room (UB303, for instance) Student: Student ID First Name Last Name Plan Sub Plan Advisor Current GPA Grade of each course The Term you got the grade for a course. The class…
Page - 1 DBMS - TASK 1: Draw an ERD and Map it to relational schema. Please complete reading page 1 before going to page 2. In this task, you will be given a text that describes a company (in page 2). Each student should complete the steps below to fully solve the task Represent the company description as an ER-diagram, including all relevant constraints as the following steps: - Each student should download Lucidchart app Every student should use Lucidchart to draw the ERD Edit Lucidchart Blank diagram Select View Insert Arrange Help 80 What's New Saved Start a free trial to access unlimited shapes and documents! X BIUAT- 2 px None None 408 Liberation Sans ▾ 10 pt + Shapes O Standard × T Flowchart 000 ☐ ODOT ☐ ☐ ☐ ☐ ☐☐ )>0 × TU Xx 14 << ΔΟ ▼ Shapes ΠΑ ☐ ☐ Name B Present MA when you create After each entity ID print screen, your name include your user ID should be shown university ID number Department 0190334 Dep_ID Employee 0190334 Name

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