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

//Last three parts not answered before You are working with a database that stores information about suppliers, parts and projects. The Supply relation records instances of a Supplier supplying a Part for a Project. The schema for the database used in this question is as follows: ( primary keys are shown underlined, foreign keys in bold). SUPPLIER (SNo, SupplierName, City) PART (PNo, PartName, Weight) PROJECT (JobNo, JobName, StartYear, Country) SUPPLY (SNo, PNo, JobNo, Quantity) Provide relational algebra (NOT SQL) queries to find the following information. NOTE: You can use the symbols s, P, etc or the words ‘PROJECT’, ‘RESTRICT’ etc . do not need to try to make efficient queries – just correct ones. Where you use a join, always show the join condition. List the quantity of parts supplied on JobNo 4745. List the weight of the Part named “Left-handed screwdriver”. List the Project name and Part name of any Parts where fewer than 500 of the part has been supplied to a particular…
Write a relational calculus based on the following relations: Professor (ProfID, ProfName, DeptNo) Course (CrsID, CrsName, Credits, DeptNo, ProfID) Department (DeptNo, DeptName) Use tuple relational calculus; 1. List all professor names, who are the owner of the courses named, "Database Design". 2. List all professor names who teach the 3-credit courses provided by the department named "Information Technology".
Identify the normal form it is in. Please make sure to provide explanations to support your answer. Convert it to BCNF. 1.GRADES (S#, C#, sem, year, F#, FName, Sname, Cname, grade, crHrs) a) Write down the following functional dependencies: S# --> C# --> F# --> b) Which normal form is the above relation in? c) Convert it to BCNF: 2.TEACHES (C#, sem, year, F#, Fname, Foffice) a) Write down the functional dependency for F#: F# --> b) Which normal form is the above relation in? c) Convert it to BCNF 3. R (a,b,c,d,e,f,g) Given that: d --> a e --> f,g a) Which normal form is the above relation in? b) Convert it to BCNF:
What are three advantages of using a surrogate key rather than the main key to access a relation instead?
Create ERD or EERD of local school library with these requirements, and write relation schema (underline primary key and connect foreign key with arrow) (use Chen Notation) 1. Book : - there may be some title with many copy/books, so ISBN isn't unique. Librarian however create ID for each book to identified them. - book can have many author, each other name should be separable to navigate/searching when needed 2. Borrow : - only those with Membership can borrow - each borrow session you need to stored 'borrow date' and 'return date' so you can calculate 'penalty fee' if it's late 3. Membership - there are Expire date for each member - there are 4 types of membership : contributor, student, university staff, normal citizen. - Personal info include : CitizenID, (if they are student/university staff you need to store student ID and staffID too), Name, Address, Faculty, Telephone Number - citizen member can only borrow 3 book at maximum, studen 5, and staff 6, and contributor 5.…
Explain the use of the terms relation, tuple, and attribute.
What is a well-structured relation?
You are working with a database that stores information about suppliers, parts and projects. The Supply relation records instances of a Supplier supplying a Part for a Project.The schema for the database used in this question is as follows: (note that primary keys are shown underlined, foreign keys in bold). SUPPLIER (SNo, SupplierName, City)PART (PNo, PartName, Weight)PROJECT (JobNo, JobName, StartYear, Country)SUPPLY (SNo, PNo, JobNo, Quantity) Provide relational algebra (NOT SQL) queries to find the following information.NOTE:• You can use the symbols σ, π, etc or the words ‘PROJECT’, ‘RESTRICT’ etc as you prefer.• You do not need to try to make efficient queries – just correct ones.• Where you use a join, always show the join condition.a. List the Project name and Part name of any Parts where fewer than 500 of the part has been supplied to a particular project.b. List the name of any Suppliers who have supplied Parts to the Project called “New Academic Building” or to the Project…
You are working with a database that stores information about suppliers, parts and projects. The Supply relation records instances of a Supplier supplying a Part for a Project.The schema for the database used in this question is as follows: (note that primary keys are shown underlined, foreign keys in bold). SUPPLIER (SNo, SupplierName, City)PART (PNo, PartName, Weight)PROJECT (JobNo, JobName, StartYear, Country)SUPPLY (SNo, PNo, JobNo, Quantity) Provide relational algebra (NOT SQL) queries to find the following information. NOTE:• You can use the symbols σ, π, etc or the words ‘PROJECT’, ‘RESTRICT’ etc as you prefer. • You do not need to try to make efficient queries – just correct ones. • Where you use a join, always show the join condition.a. List the quantity of parts supplied on JobNo 4745.b. List the weight of the Part named “Left-handed screwdriver”.c. List the Project name and Part name of any Parts where fewer than 500 of the part has been supplied to a particular project.d.…
You are working with a database that stores information about suppliers, parts and projects. The Supply relation records instances of a Supplier supplying a Part for a Project.The schema for the database used in this question is as follows: (note that primary keys are shown underlined, foreign keys in bold).SUPPLIER (SNo, SupplierName, City)PART (PNo, PartName, Weight)PROJECT (JobNo, JobName, StartYear, Country)SUPPLY (SNo, PNo, JobNo, Quantity)Provide relational algebra (NOT SQL) queries to find the following information. Each question is worth 2 marks.NOTE:• You can use the symbols etc or the words ‘PROJECT’, ‘RESTRICT’ etc as you prefer. • You do not need to try to make efficient queries – just correct ones. • Where you use a join, always show the join condition.a. List the quantity of parts supplied on JobNo 4745.b. List the weight of the Part named “Left-handed screwdriver”.c. List the Project name and Part name of any Parts where fewer than 500 of the part has been supplied to a…
just answer true/false a]Disjointness means that every entity of a supertype must be an entity in one of the subtypes in the generalization hierarchy. b]Record is a set of more fields that describe a person, place or thing. c]Cardinality is the number of tuples in a relation. d]Referential integrity must have null values only.
Normalize the following given data to 1/2/3 NF. State the relations schema after everynormalization.