Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

9. Business rules use simple language to establish definitions of entities, attributes, relationships, and constraints. For instance, a business rule establishing that entities can have

image text in transcribed

9. Business rules use simple language to establish definitions of entities, attributes, relationships, and constraints. For instance, a business rule establishing that entities can have multiple attributes, and that each available attribute may be associated with only one entity, might be stated as "An employee may be assigned multiple devices" and "Each device may be assigned to only one employee". Classify the relationship between EMPLOYEES and DEVICES in this example using shorthand notation. a. 1..1 b. .. c. M:N d. 1:M 10. In the context of relational databases, a column in a relational table is associated with the (s) of a real-world person, place, thing, or event. a. entity b. attributes c. relationships d. constraints 11. Determine which of the following simple-language expressions represents a valid constraint. a. EMPLOYEE manages STORE b. CUSTOMER generates INVOICE c. STUDENT takes CLASS d. Each CONTAINER contains between 0 and 100 UNITs. 12. Which of the following is true of business rules? a. They allow the designer to set company policies with regard to data. b. They allow the designer to develop business processes. c. They can serve as a communication tool between the users and designers. d. They provide a framework for the company's self-actualization. 13. What component of a particular business rule can be analyzed in order to infer whether the type of relationship between two entities can be represented in notation by 1:1, 1:M, or M:N ? a. the nouns present in the business rule b. the type of database being used by the DBMS c. how many instances are on each side of the relationship d. end-user perceptions of the business rule 14. Relational algebra defines the theoretical way of manipulating table contents using a. project b. data files c. relational operators d. attribute manipulation 15. The operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple. a. Select b. Join c. Union d. Intersection 16. The result which operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match. a. Join b. Cartesian product c. Intersection d. Set difference

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

- pi Answered: 1 week ago

Answered: 1 week ago