Answered: Analyze the diagram bellow and…

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

Related questions

Concept explainers

Question

Analyze the diagram bellow and transform it from conceptual model to a logical model using the textual notation.

You must represent it by respecting the following textual notation.

Table name: is represented by the first word in capital letters in front of the parentheses. i.e. TABLE ();
Columns name: are inside the parentheses separated by commas. i.e. (column1, column2);
PK: Stay with the column which is the primary key. i.e. TABLE (column1 (PK), column2);
FK: Stay with the column which is the foreign key. i.e. TABLE (column1 (PK), column2, column3 (FK));
CPK: Stay with the column that makes up the composite primary key. i.e. TABLE ((column1, column2 (CPK)), column3);

Student
studentld INT
studentName VARCHAR(20)
studentBirthday DATE
studentAddress VARCHAR(25)
City
cityld INT
cityName VARCHAR (20)

Expert Solution

Step by step

Solved in 2 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions