Question

An associative entity or intersection table is used to resolve many-to-many relationships in the relational model....

  1. An associative entity or intersection table is used to resolve many-to-many relationships in the relational model.
    1. True
    2. False
  2. Database design primarily concentrates on modeling processes.
    1. True
    2. False
  3. A characteristics of a good business rule is that it is technology-oriented.
    1. True
    2. False
  4. Names of entities and attributes should use vernacular of the business.
    1. True
    2. False
  5. Weak entities are independent of any other entity.
    1. True
    2. False
0 0
Add a comment Improve this question Transcribed image text
Answer #1

1)An associative entity or intersection table is used to resolve many-to-many relationships in the relational model.

True,associaitve entity maps two or more tables by using reference of primary key.

2) Database design primarily concentrates on modeling processes.

True,modeling is the first step in the process of datebase design and important part of database design

3) A characteristics of a good business rule is that it is technology-oriented.

True,bussiness rules uses technology to create new data

4) Names of entities and attributes should use vernacular of the business.

True

5) Weak entities are independent of any other entity.

False,weak entities must depends on strong entity it cannot be identified alone.

Add a comment
Know the answer?
Add Answer to:
An associative entity or intersection table is used to resolve many-to-many relationships in the relational model....
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

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
  • Please help me answer these: In the relational database model, an entity consists of one and...

    Please help me answer these: In the relational database model, an entity consists of one and only one entity instance (or record). A. True B. False 2. In the relational database model, the foreign key name does NOT have to be the same as the primary key name. A. True B. False 3. Logical relationships between tables (or entities) in the relational database model are created with primary and candidate keys. A. True B. False 4. In the relational database...

  • Project: Relational Modeling Note: This project must be unique in its design (E-R diagram) and implementation...

    Project: Relational Modeling Note: This project must be unique in its design (E-R diagram) and implementation (SQL queries). You are not to copy or use any part of a database project that was previously submitted or appears on the Web, in a textbook, or otherwise made available via an external source. Contact your instructor if you have any questions regarding this requirement. Deliverables for Part 1: (1) Project Description. Provide an overview of your project identifying the major components as...

  • Question 29 What entity type is used to convert a many-to-many relationship to two one-to-many relationships?...

    Question 29 What entity type is used to convert a many-to-many relationship to two one-to-many relationships? repeating entity intersection entity associative entity attributive entity Question 30 A many-to-many relationship can be directly modeled in a relational database such as Microsoft Access. True False Question 31 Which order is correct for the designer to normalize a data structure? I. Remove all repeating groups and identify the primary key. II. Remove any transitive dependencies. III. Remove all partial dependencies and place them...

  • 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...

  • For this DATABASE homework assignment you will create an Entity Relationship model for a business case...

    For this DATABASE homework assignment you will create an Entity Relationship model for a business case and then convert the model to a set of relations.  Read through the following business case for the “Drum Corps International”  Create an Entity relationship model with the necessary entities, attributes, identifiers and relationships to capture the data requirements.  All relationships should be labeled with verb phrases.  Use UML notation for this work.  Relationship lines should not cross. ...

  • TM-315 DATABASE SYSTEMS Please help me to draw an ERD and the Relational Schema and please...

    TM-315 DATABASE SYSTEMS Please help me to draw an ERD and the Relational Schema and please mark the Primary and Foreign Key ..... Deliverable: Word document with grade sheet followed by Part 1 ERD and the Part 2 relational schema. Part 1: Draw the ERD for the following situation. 8 pts Be sure to: Convert all many-to-many relationships to associative entities. Make sure each regular entity has an appropriate identifier. Make sure attribute names are unique within the ERD Wally...

  • This assignment allows students to demonstrate their skills in the area of designing relational databases to...

    This assignment allows students to demonstrate their skills in the area of designing relational databases to satisfy specific business rules and requirements. The deliverables for this assignment include an Entity Relationship Diagram and detailed documentation describing the database design and structure. In this assignment you will be provided with a description of an application (below) to create an entityrelationship diagram (ERD) and design accompanying table layout using sound relational modeling concepts and practices. The relationships between the entities and the...

  • The employee is table, the best candidate for primary key is Select one: a. Department ID...

    The employee is table, the best candidate for primary key is Select one: a. Department ID b. Employee hiredate c. Employee ID d. Employee salary Question 2 A primary key can be composed of more than one attribute. Select one: True False Question 3 A foreign key allows you to join two tables. Select one: True False Question 4 Given two tables, department (dept_id, dept_location, dept_name) and EMPLOYEE(emp_id, emp_name, emp_dept_id, emp_name, emp_salary), which attribute (column) is the foreign key? Select...

  • Q1.a) Based on the business rules, you are expected to construct an Entity-Relationship (ER) diagram. The...

    Q1.a) Based on the business rules, you are expected to construct an Entity-Relationship (ER) diagram. The ER diagram should include entities, attributes (if there are less than three specified in the business statements, please add some extra attributes), identifiers and corresponding data types, the relationships among entities with cardinality and associative entities. .b) Extend Q1.a) to apply generalization/specialization technique to construct an Enhanced-ER (EER) diagram. The EER diagram should specify the complete (total) and disjoint (mutuallyexclusive) constraints on the generalization/specialization....

  • 1) Create Conceptual Schema Diagram 2) Create a fully attributed Loagical Data Model Diagram 3) Create...

    1) Create Conceptual Schema Diagram 2) Create a fully attributed Loagical Data Model Diagram 3) Create the SQL script that will generate the data model Develop an EER model for the following situation using the traditional EER notation, the Visio notation, or the subtypes inside supertypes notation, as specified by your instructor: Wally Los Gatos and his partner Henry Chordate have formed a new limited partnership, Fin and Finicky Security Consultants. Fin and Finicky consults with corporations to determine their...

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