Question

Please answer true or false 27) Relationship instances occur when an instance of one entity is...

Please answer true or false

27) Relationship instances occur when an instance of one entity is related to an instance of another entity via a relationship.

28) Two columns of a relational table can have the same values.

29) If one of two identical relational tables has the first row moved to the last place, those two relational tables are no longer identical.

30) An entity and its 1:1 unary relationship are mapped as one relation.

31) An entity and its M:N unary relationship are mapped as one relation.

32) The relation resulting from mapping a weak entity (with a 1:M identifying relationship) has a composite primary key that is composed of the partial identifier and a foreign key corresponding to the primary key of the owner entity.

33) Every attribute appears only once in an ER diagram

34) A restriction specifying that no salary entered in the salary column can be higher than $300,000 is an example of a business rule.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

27) True
28) True
29) False
30) True
31) False
32) True
33) True
34) True
Add a comment
Know the answer?
Add Answer to:
Please answer true or false 27) Relationship instances occur when an instance of one entity is...
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
  • Which of the following is NOT true? Mapping an M:N relationship that has no attributes will...

    Which of the following is NOT true? Mapping an M:N relationship that has no attributes will result in: A new relation Two foreign keys A composite primary key A foreign key in both of the relations mapped from the involved entities

  • Please answer the true false questions 20) Analytical databases collect and present operational information in support...

    Please answer the true false questions 20) Analytical databases collect and present operational information in support of daily operational procedures and processes. 21) Analytical information is based on operational information. 22) Each instance of a weak entity must participate in one instance of the identifying relationship. 23) A weak entity that has a 1:1 identifying relationship with its owner, must have a partial key. 24) Each instance of a weak entity must participate in one instance of the identifying relationship....

  • This is symbolized by a circle over a single line in an entity relationship diagram. It...

    This is symbolized by a circle over a single line in an entity relationship diagram. It signifies that the supertype does NOT have to be one of the specified subtypes. Partial completeness Total completeness System completeness Associative completeness A supertype entity can contain as many as ____ subtype entities. 10 1 100 no defined limit When you set up an Entity Relationship Diagram, and have a many-to-many relationship, this entity is created to avoid problems inherent to a many-to-many relationship....

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

  • Question 4 To represent a one-to-many relationship in a relational database design, _____. Group of answer...

    Question 4 To represent a one-to-many relationship in a relational database design, _____. Group of answer choices the key of the child is placed as a foreign key into the parent the key of the parent is placed as a foreign key into the child an intersection table must be created the key of the table on the "many" side is placed in the table on the "one" side the keys of both tables are joined into a composite key...

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

  • (MMU) has decided to consolidate the functionality of three small overlapping database systems, which support applications...

    (MMU) has decided to consolidate the functionality of three small overlapping database systems, which support applications for 1) teaching (e.g. instructor assignment and evaluation), for 2) registration (e.g. online course status, waiting lists), and for 3) student records (e.g. transcript generation) The resulting new system will support the following enterprise description: Professors and GTAs are assigned to teach the sections of each class being offered in a semester. At the end of the semester, they get a "team rating" (professors...

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

  • New to DB's Please help! You are designing and creating a database named COMPANY for an HR (Human Resource) Dept of...

    New to DB's Please help! You are designing and creating a database named COMPANY for an HR (Human Resource) Dept of a Software Consulting Company to manage their employees and their assigned work (projects) in the company First Step to Design and Create a Database is Creating an E-R Diagram by Identifying Entities, Attributes and Relationships between any two Entities to Create a Company Database Scheme. 1. Create an E-R Diagram for the Company database from the raw data files...

  • Please read the article and answer about questions. You and the Law Business and law are...

    Please read the article and answer about questions. You and the Law Business and law are inseparable. For B-Money, the two predictably merged when he was negotiat- ing a deal for his tracks. At other times, the merger is unpredictable, like when your business faces an unexpected auto accident, product recall, or government regulation change. In either type of situation, when business owners know the law, they can better protect themselves and sometimes even avoid the problems completely. This chapter...

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