ZuoTi.Pro
Question

2. The following figure shows an ER schema for a database that can be used to...


The following figure shows an ER schema for a database that can be used to keep track of transport ships and their locations for maritime authorities. Map this schema into a relational schema and specify all primary keys and foreign keys. Use arrows to specify the relationships. Use descriptive names for foreign keys. 


image.png

engineering   Computer-Science   
1 0

> in which book is the exercise?

GeorgeAnd899 Tue, Oct 19, 2021 7:27 AM

Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

✔ Recommended Answer
Answer #1

Relational Schema

SHIP(Sname, Owner, Type)

SHIP_MOVEMENT(Sname,Date,Time,Latitude, Longitude)

SHIP_TYPE(Type,Tonnage,Hull)

PORT_VISIT(Sname, Pname, Start_Date,End_Date)

PORT(Sname,Pname, InStateCountryName, OutSeaOceanLakeName)

STATECOUNTRY(Name, Continent)

SEAOCEANLAKE(Name)

bold attributes are primary keys and italicized are foreign keys)

Do ask if any doubt.

1 3

> in which book is the exercise?

GeorgeAnd899 Tue, Oct 19, 2021 7:28 AM

Add a comment
Know the answer?
Add Answer to:
2. The following figure shows an ER schema for a database that can be used to...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Similar Homework Help Questions

  • Map the ER diagram into a relational database schema. Describe each relation schema in parenthesized notation...

    Map the ER diagram into a relational database schema. Describe each relation schema in parenthesized notation (not SQL) underlining the primary key. For each relation, describe any applicable integrity constraints, e.g., foreign key, referential integrity, not null, etc.

  • 2. The following figure shows an ER schema for a university database. a) Map this schema...

    2. The following figure shows an ER schema for a university database. a) Map this schema into a relational schema b)Show the SQL statements needed to create the relations, using proper constraints. If your translation cannot capture any constraints in the ER diagram, explain why. COffice CName CPhone COLLEGE 0. 1 D Rank Office IName IPhone INSTRUCTOR D EAN (0.NO CStartDate (0.1) <ADMINS . CHIAR (1,1) EMPLOYS (MName FName LName (SName DOB DName Sid IO.NO Name Poate DEPT on H...

  • Figure 2 shows the ER diagram that captures important information about Students, Courses and classes in MIT.

    Figure 2 shows the ER diagram that captures important information about Students, Courses and classes in MIT. Figure 2: Data Model for Student course registration a. Convert the ER diagram into a relational database schema. Be certain to indicate primary keys (underline).    Eg. Student (StudentID:text: Student_name:text,.....)    NB: You are required to identify many-to-many relationships in the ER diagram and include Associative / Bridge entities.

  • Part I. Mapping an (E)ER schema to a relational database schema (46 points) NOTE o Each...

    Part I. Mapping an (E)ER schema to a relational database schema (46 points) NOTE o Each relation sachem should have a primary key (PK) when you answer. • To present the reference table of the foreign key (e.g., FK, FK1, K2), use an arrow. Do not use the relationship cardinality symbols of crow's foot notation in the relational database schema. o It is not required to specify the domain constraint (e.g., data type and length) of each attribute. 1. (12...

  • This is how i mapped the relational schema diagram. would this be correct? i feel like...

    This is how i mapped the relational schema diagram. would this be correct? i feel like i am missing something. ud bundle at the start of the class on the due date. ment. 1. (10 pts) Use the ER-to-relational mapping algorithm to map the BANK ER diagram to a relational schema diagram. Prepare the diagram using ERDPlus and make sure to specify all primary keys and foreign keys. (Position the relations so that the arcs from the foreign keys to...

  • Given the following relational database schema (primary keys are bold and underlined). Answer questions 2.1 to 2.4 Orde...

    Given the following relational database schema (primary keys are bold and underlined). Answer questions 2.1 to 2.4 Orders(orderld, customerld, dateOrdered, dateRequired, status) Customer(customerld, customerLastName, customerStreet, customerCity, customerState, customer Lip OrderDetails(orderld.productld, quantity, lineNumber, amount) Products(productld, name, description, quantity, unitPrice) Account(accountNumber, customerld, dateOpened, creditCard, mailingStreet, mailingCity, mailingState, mailingZip) 2.1 (2 Points) List all possible foreign keys. For each foreign key list both the referencing and referenced relations. 2.2 (2 Points) Devise a reasonable database instance by filling the tables with data of...

  • 1. {90 points} Your task is to design a 'Company database capable of storing information about...

    1. {90 points} Your task is to design a 'Company database capable of storing information about EM- PLOYEE(S), DEPARTMENT(s), and PROJECT(s). Knowing that: We store each employee's name composite attribute - {10 points}), social security number, address, salary, and telephone number. An employee is assigned to one department, but may work on several projects which are not necessarily controlled by the same department. We keep track of the number of hours that an employee works on each project - {10...

  • 4.   Review Exercise 2 on Page 154 in your textbook. Construct a relational database, including tables,...

    4.   Review Exercise 2 on Page 154 in your textbook. Construct a relational database, including tables, to handle the entities, attributes, and relationships included in the exercise. For each relation (table) in your relational database, clearly specify primary key, alternate key(s), and foreign keys. (9pts) The State of New York certifies firefighters throughout the state and must keep track of all of them, as well as of the state’s fire departments. Each fire department has a unique department number, a...

  • 4.   Review Exercise 2 on Page 154 in your textbook. Construct a relational database, including tables,...

    4.   Review Exercise 2 on Page 154 in your textbook. Construct a relational database, including tables, to handle the entities, attributes, and relationships included in the exercise. For each relation (table) in your relational database, clearly specify primary key, alternate key(s), and foreign keys. (9pts) The State of New York certifies firefighters throughout the state and must keep track of all of them, as well as of the state’s fire departments. Each fire department has a unique department number, a...

  • Written Assignment#1: Preliminary Database Design Preliminary Database Design The purpose of this project is to give...

    Written Assignment#1: Preliminary Database Design Preliminary Database Design The purpose of this project is to give you some experience in database design. We will explore both theoretical and practical aspects of the database design steps. Once you master it well, it is a simple matter of translating the theoretical concepts you developed into the terms of a concrete DBMS to implement the database. Conceptual/Logical Database Design You must choose some facet of real life that you feel needs to be...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT