3) Given the ER diagram depicted in the following diagram,I.define schemas (name of attribute, attribute type with length, PK, FK) for DBMSimplementation;I.define cardinality of relationship and explain your answer;II.define FK and other constrains that you decm relevant.costenameedertdoamedageessoEMPLOYEEMedical policyDEPENDENT

Given ER diagram contains two entities Employee and Dependent. The attributes of Employee are essn,…

3) Given the ER diagram depicted in the following diagram, I. define schemas (name of attribute, attribute type with length, PK, FK) for DBMS implementation; define cardinality of relationship and explain your answer; definc FK and other constrains that you decm relevant. I. I. cost ename Rdent doame dage essn ΕMPLOYEΕ Medical policy DEPENDENT

3) Given the ER diagram depicted in the following diagram, I. define schemas (name of attribute, attribute type with length, PK, FK) for DBMS implementation; define cardinality of relationship and explain your answer; definc FK and other constrains that you decm relevant. I. I. cost ename Rdent doame dage essn ΕMPLOYEΕ Medical policy DEPENDENT

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

Q1 Extract and write down the DB Schema for the following E-R Diagram. You need to write the name, attributes, and keys (need to be underlined) for each relation in your schema. co de result Exam sin description pfname (0, N) (0, N) Patient UnderTakes cost plname (0, N) sex start_date end_date (1, N) (0, N) Hosted By doctorld start_date tel (1, 1) (1, N) rooms office Doctor Worksin Clinic cname dfname diname (1, 1) (1, 1) Manages specialty 00
MIS150 hires qualified employees to purchase merchandises from vendors. Develop an appropriate enhanced entity relationship diagram for MIS 150 database that only describes MIS 150 employees to purchase merchandises from vendors for increasing inventory, and to handle purchasing payments for the vendors that could be either credit and/or cash. The diagram can only have one-to-many relationship and cannot contain any irrelevant entities to avoid points deduction. (Use Word’s Shapes, and Text Box to draw enhanced entity relationship diagram
You are required to: Provide a normalized relational logical schema for the same database (NB It is not mandatory to report the restructured ER diagram) Define referential integrity constraints for 2 relationships of your choice among those defined in the conceptual schema solution: AUTHOR( author_id , name, surname) BOOK ( ISBN , title , num_page s , price ) CUSTOMER( customer_id , phone_number*, type, name*, surname*, vat_number*) CLERK( clerk_id , name) BUY( customer_id, clerk_id, ISBN ) WRITTEN_BY( author_id, ISBN ) 1) WRITTEN_BY (author_id) REFERENCES AUTHOR(author_id) WRITTEN_BY (ISBN) REFERENCES BOOK(ISBN) 2) BUY(customer_id) REFERENCES CUSTOMER(customer_id) BUY (clerk_id) REFERENCES CLERK(clerk_id) BUY (ISBN) REFERENCES BOOK (ISBN) i gave the solution. but i do not have any idea where it came from and how im supposed to formulate a similar solution so please help me understand how was this was reached and how i should solve these type of questions in…
Subject: DatabaseIdentify ALL errors and correction on the entity relationship diagram (ERD) given in Figure 5.i. Circle the errors identified on the diagram.ii. For each error identified, correct them. Show your corrections either by redrawing the corrected diagram OR by describing how the errors should be corrected next to the circles that you have identified.
Hi, I could use help on making crows-foot notation ERD's for this problem. Ultimately it should be shown in boxes that have the entities, primary key, foreign key, and attributes. Each should be connected with one-to-one, one-to-many, or many-to-many relationships. Please provide explanation so I can understand :)
Question 12 Differentiate between the requirements of entity integrity and referential integrity constrains with examples.
All of you must be familier with human resources system (employee database). Soplease design database for a human resources system that at least has 4 entitiesinvolved and for the 4 entities please do the following:a. Create the tables that conform to 3NF.b. Draw the Crow’s Foot ERD to reflect the dependency and relationshipdiagrams;c. For all entities/tables created please write the MASTER and TRANSACTIONdata accordingly!d. Use SQL commands to to do selection which involve 1 table, 2 tables, and 3tables.
I want to create logical database design: 1. Normalize the relations to at least third normal form (3NF) using proper standard E-R diagram notation. Provide the appropriate relational schema reduction. 2. Identify the primary and foreign keys for each relation (using appropriate notation). Maybe either list the primary and foreign keys or generate a schema diagram??? 3. Identify and describe any indexes needed to speed up searches on non-key attributes – can you explain it too? So I would understand why you come up with the answer please? 4. Identify and describe unique, conditional (check), non-null, referential integrity, or other constraints needed to guarantee the integrity of the database. 5. Describe the set of business or workflow rules applicable to your project. Next, describe at what point in the workflow you will implement the business or workflow logic and the justification for doing so.Below are my conceptual design.
(ii) Four entities of the organization are: Worker, Customer, Product and Department. (a) Suggest an identifier, with justification, for any three entities. (b) Describe three relationships that can be inferred from these entities. (iii) Give relational database tables for any two of the entities you used to describe relationships in ii(b). For example STUDENT( StedentMaricule, name, gender, DOB) for the entity student.
Discuss how a DBA will verify that proper PK/FK relationships are established - do not forget the Associative Entity fix - e.g. certain default parameters are set, like NULL or NOT NULL, and when. You may want to explain what a DBA would have to verify if a given entity has more than one role within a system - read: is used in several relationships. Please help me answer this.
Develop a logical data model based on the following requirements:• Refinement of the conceptual model - including a refined Enhanced Entity-Relationship (EER) diagram.• Derivation of relations from the refined conceptual model.• Validation of logical model using normalization to BCNF.• Validation of logical model against corresponding user transactions.• Definition of integrity constraints including:- Primary key constraints.- Referential Integrity (foreign key) constraints.- Entity integrity (NULL and default value) constraints.- Alternate key constraints.- General constraints if any. Entities Airplane Model Technician Expertise Traffic Controller Medical Examination Union Test Testing Event Relationships Airplane is of Model (1:M) Technician has Expertise in Model (M:M) Traffic Controller undergoes Medical Examination (1:1) Employee belongs to Union (1:1) Airplane is Tested using Test (M:M) Testing Event records Airplane, Technician, and Test (M:M:M) Attributes Airplane…
A) Let suppose if you are a database designer, and if you were designing a Web-based System to make Online Coffee Shop for your friend and decide to sell coffee and deliver it, which DBMS architecture and model you choose and Why? Explain your answer with the help of other models. Identify entities, relationships, attributes while designing the database.(There should be at least five tables or more than that). List cardinalities on both ends of each relationship (0..1, 1..*, 1..1) - minimum 6 (2 for each relationship identified between entities)