1. Convert the conceptual ERD to Logical ERD 2. Derive the relation schema. Figure 6: AUTHOR PUBLICATION pub_ID (pk) publish_date author_num (pk) author Iname author fname author phone (MANDATORY, or) ORGANIZATION BOOK ARTICLE book title book category book publisher article_title keyword org ID (pk) org name org address shedn JOURNAL journal ID (pk) journal name SUBJECT LI subject_name (pk) category year publisher volume

1. Convert the conceptual ERD to Logical ERD 2. Derive the relation schema. Figure 6: AUTHOR PUBLICATION pub_ID (pk) publish_date author_num (pk) author Iname author fname author phone (MANDATORY, or) ORGANIZATION BOOK ARTICLE book title book category book publisher article_title keyword org ID (pk) org name org address shedn JOURNAL journal ID (pk) journal name SUBJECT LI subject_name (pk) category year publisher volume

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

1)make er diagram for this picture(in a very professional way). 2) explain relation between table(like one to one or many to one or many to many).(in a very professional way).
Map the EER diagram to a relational schema and transform the relation into 3NF
Design a Relational Database by Mapping the following Entity-Relationship Diagram (ERD) into Relational Model. You must clearly determine the PK of each relation. Also, you should show the links between FKs and PKs in your answer. SName Owner SHIP MOVEMENT PName HISTORY HOME PORT SHIP PORT Latitude (0,") VISITS (0.") Timestamp Longitude N N N (1.1) IN TYPE ON 1 1 Date Time StartDate VISITS Type EndDate Tonnage SHIP TYPE Name STATE/COUNTRY Name SEA/OCEAN/LAKE Hull Continent
Translate the following ER Diagram into relational model. Show different relations that will result in addition to their attributes, PKs and FKs. Newspaper AK newsPaperID newsPaperName newsPaperAddress Work for Actor Joumalist AK actorID AK journalistID -interview- firstName journalistName lastName dateOFbirth nationality write Edition Article -publishedIN- AK editionID PK articlelD editionDate article Title related To Topic AK topicID topicWording
2. The relations SE Developer and Programmer below are mapped from the ERD on their left. Determine if they are in 4NF or not. If not, normalize it to 4NF. SW-Developer ID SW-Developer skill ID language proficiency language proficiency Programmer ID Programmer language phone ID language phone
Define the term primary key in terms of functional dependencies
Create a relational schema for this diagram
1)A tuple is a named column of a relation. True or alse2)Each attribute in a relation has a distinct name. T/F3)The degree of a relation is the number of attributes it contains. T/F4)A foreign key is the candidate key that is selected to identify tuples. T/F
120. Which formal method that locates and analyses relation schemas on the basis of their primary, candidate keys, and the FD’s that are present among the attributes of these schemas: a. Functional dependency b. Database modeling c. Normalization d. Decomposition
Map the EER diagram to a relational schema and transform the relation into 3NF
b. Indicate for each of the following potential functional dependencies, whether it is indeed a functional dependence or NOT.1. NUMBER → TITLE2. STARTPAGE → ENDPAGE3. NUMBER → (STARTPAGE, ENDPAGE, PUBLICATIONS, VOLUME)4. TECHNICAL_REPORT_ID → NUMBER5. (PUBLICATION, VOLUME) → YEAR 6. TITLE → NUMBER
Map the EER diagram to a relational schema and transform the relation into 3NF