HomeworkLib
Question

Consider the following tables: PAINTER(P_NUMBER, P_LNAME, P_FNAME, P_MAIL) PAINTING(PAINT_CODE, PAINT_TITLE, P_NUMBER) For the tables given above,...

Consider the following tables:

PAINTER(P_NUMBER, P_LNAME, P_FNAME, P_MAIL)

PAINTING(PAINT_CODE, PAINT_TITLE, P_NUMBER)

For the tables given above, work on the problems below:

1. For each table, identify the primary key.

2. For each table, identify the foreign key(s).

3. Identify at least one candidate key. If there are no candidate keys, give an example of an attribute that could be used as a candidate key.

4. For one of the tables, give examples of a superkey and a secondary key.

5. For the given tables, explain how entity integrity and referential integrity could be violated. Give specific examples.

6. Use Visio to create a detailed Crow's Foot ERD. The diagram must include all entities, attributes, and relationships. Primary keys and foreign keys must be clearly identified on the diagram.
engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

0 0
Add a comment
Know the answer?
Add Answer to:
Consider the following tables: PAINTER(P_NUMBER, P_LNAME, P_FNAME, P_MAIL) PAINTING(PAINT_CODE, PAINT_TITLE, P_NUMBER) For the tables given above,...
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

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Consider the following tables: STORAGE(ST_CODE, ST_NAME, ST_LOCATION, ST_CONTACT) ITEM(IT_CODE, IT_DESCRIPTION, IT_QUANTITY, ST_CODE) For the tables given...

    Consider the following tables: STORAGE(ST_CODE, ST_NAME, ST_LOCATION, ST_CONTACT) ITEM(IT_CODE, IT_DESCRIPTION, IT_QUANTITY, ST_CODE) For the tables given above, work on the problems below: 4. For one of the tables, give examples of a superkey and a secondary key. 5. For the given tables, explain how entity integrity and referential integrity could be violated. Give specific examples. 6. Use Visio to create a detailed Crow's Foot ERD. The diagram must include all entities, attributes, and relationships. Primary keys and foreign keys must...

  • QUESTION 1 What is the most common relationship within a relational database? Select the best answer...

    QUESTION 1 What is the most common relationship within a relational database? Select the best answer from the following. One-To-One relationship. o One-To-Many relationship. Many-To-Many relationship. Zero-To-Zero relationship. QUESTION 2 What is an "entity'? Select the best answer from the following. An entity, for our purposes, is the same as a table in the database. An entity represents one of the columns in an individual table. There are no entities in a relational database. Entities are only part of NoSQL...

  • QUESTION 1 1. Use the following business rules to draw the fully labeled Crow's Foot ERD...

    QUESTION 1 1. Use the following business rules to draw the fully labeled Crow's Foot ERD in Visio. The diagram must include all entities, attributes, and relationships. Primary keys and foreign keys must be clearly identified on the diagram. Write all appropriate connectivities and cardinalities on the ERD. a). Each city may have many sport teams. The number of teams is limited to 20 per city. b). Each team belongs to one and only city. c). Each team has at...

  • QUESTION 1 1. Use the following business rules to draw the fully labeled Crow's Foot ERD...

    QUESTION 1 1. Use the following business rules to draw the fully labeled Crow's Foot ERD in Visio. The diagram must include all entities, attributes, and relationships. Primary keys and foreign keys must be clearly identified on the diagram. Write all appropriate connectivities and cardinalities on the ERD. a). Each city may have many sport teams. The number of teams is limited to 20 per city. b). Each team belongs to one and only city. c). Each team has at...

  • Please answer the above questions as I wish to confirm my answers. Thanks. 1. Define the...

    Please answer the above questions as I wish to confirm my answers. Thanks. 1. Define the following terms as they apply to the relational model of data: domain, attribute, n- tuple, relation schema, relation state, degree of a relation, relational database schema, and relational database state. 2. Why are tuples in a relation not ordered? 3. Why are duplicate tuples not allowed in a relation? 4. What is the difference between a key and a superkey? 5. Why do we...

  • Given the information below, create the fully labeled Crow's Foot ERD using a specialization hierarchy where...

    Given the information below, create the fully labeled Crow's Foot ERD using a specialization hierarchy where appropriate (use Visio). The ERD must contain all primary keys, foreign keys, and main attributes. Business rules are defined as follows: A company owns three types of vehicles: cars, trucks, and motorcycles. When delivered, each vehicle goes through inspection. Each vehicle creates one record in the INSPECTION table. One record in the INSPECTION table is related to one vehicle. All vehicles share common basic...

  • Q) Integrity Constraints question. Consider following tables (bold are Primary Keys) •Hotel (hotelNo, hotelName, city) •Room...

    Q) Integrity Constraints question. Consider following tables (bold are Primary Keys) •Hotel (hotelNo, hotelName, city) •Room (roomNo, hotelNo, type, price) •Booking (hotelNo, guestNo, dateFrom, dateTo, roomNo) •Guest (guestNo, guestName, guestAddress) Identify the foreign keys in this schema, Explain how the entity and referential integrity rules apply to these relations.

  • A small surgery center needs your help to create a database. The office manager has identified...

    A small surgery center needs your help to create a database. The office manager has identified the following types of data (entities): patients, doctors, procedures and appointments. Please identify the attributes and primary keys needed for each of the entities. Identify the data types you would use for each of the attributes. Determine the relationships between the entities and find the one-to-many and many-to-many relationships. Use the ER matrix to determine the relationships. Create an ER diagram using Visio based...

  • Which of the following describes referential integrity? A. A Primary Key of a relational table must...

    Which of the following describes referential integrity? A. A Primary Key of a relational table must not contain a null value B. One fact must not be in multiple places C. The value for a foreign key attribute must either be null or match the one of the data value of that attribute in the table in which the attribute is a primary key D. Referential Integrity is a principle that prevents the use of redundancy, avoids null values and...

  • need help! 1. To keep track of vendors and products they supply, XYZCorp. uses the table...

    need help! 1. To keep track of vendors and products they supply, XYZCorp. uses the table structure shown below. Assuming that the sample data are representative, draw a dependency diagram in Visio that shows all functional dependencies including both partial and transitive dependencies. (Hint: Look at the sample values to determine the nature of the relationships.) VEND TYPE Non-profit organization Non-profit organization Profit organization Profit organization Profit organization PART CODE 1234 PART DESC Logic Chip VEND NAME Fast Chips VEND...

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