Q1) B) Consider you have Train Station database, with the following relations: Train(train-no., capacity, source-city, distination-city, ticket-price, station-code) Station (city, distination-city, No-of-trains, country, station-code, address, station-name) Answer the following: 1- specify the primary key (or keys) and the foreign key (or keys) in each relation. If table does not have a foreign key, write None. 2- draw the schema diagram of the Train Station database.

Q1) B) Consider you have Train Station database, with the following relations: Train(train-no., capacity, source-city, distination-city, ticket-price, station-code) Station (city, distination-city, No-of-trains, country, station-code, address, station-name) Answer the following: 1- specify the primary key (or keys) and the foreign key (or keys) in each relation. If table does not have a foreign key, write None. 2- draw the schema diagram of the Train Station database.

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

Given the following relations (the primary keys are underlined): MATCH (CodM, Home Team VisitingTeam, Date,League) PLAYER (CodP, Name, Surname, Role, Nation, Team) GOAL (CodP, CodM, MinutesIntoTheMatch) YELIOW-CARDS (CodP, CodM, MinutesIntoTheMatch) Please note that MinutesIntoTheMatch indicates the time at which either the goal was scored or the yellow card was cautioned (e.g.. between 1st and 90th). Write SQL Query for each match in which no more than 2 players playing as defender (role= Defender) were cautioned with a yellow card, show match code date on which the match was held, and total number of goals scored by each player
Q3) consider you have the Library database with the following relations, where the primary keys are underlined: Book (bookID, name, auther, No.-of-pages, section-name, category) Section(section-name, section-admin, no-of-books, library-code) Library (library-name, address, no-of-sections, manager-name, library-code, country) Answer the following SQL queries: 4. Find the books names that have pages between 300 and 600. 5- Find the address and number of sections in the libraries of united states and order them by the manger name.
Describe three circumstances when a surrogate key for the primary key of a relation should be created.
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?
Create ERD of a hospital with these requirements "and then" write relation schema (underline primary key and connect foreign key with arrow): (use Chen Notation) 1. Hospital have many department, each department have it's own ID, name, and head of department. 2. Hospital need to collect Patient data included : ID, Name, Sexuality, Age, Address, Health Insurance, Telnum 3, Patient may have data stored about people they can contact, should be more than 1 people they can contact 4. Doctor should have : DocID, Name, Sex, TelNum, Specialty, Years of service, Salary, Qualification 5. 1 doctor can be assigned to only 1 department 6. some doctor may not have their assigned patient 7. patient can be assigned to more than 1 doctor for treatment 8. each treatment shall be stored (date, detail, next appointment) Specification for the diagram: - describe what should be describe and what can be describe inside the diagram - also explain others that can be describe inside the diagram briefly (don't…
Informally describe the conditions to be met for a relation to be in Second Normal Form. In terms of functional dependency, describe why the following CUSTOMER_PURCHASE relation is not in second normal form. This table describes every instance of an individual Customer purchasing a Product. How would this relation suffer from Update Anomalies? CUSTOMER_PURCHASE (CUSTOMER_ID, PRODUCT_ID, PURCHASE_DATE, PURCHASE_AMT, PRODUCT_DESCRIPTION, CUSTOMER_NAME) Note the relation’s primary key is underlined
Normalize the following given data to 1/2/3 NF. State the relations schema after everynormalization.
explanation of three circumstances where a substitute key for a relation's primary key should be created?