Explain the purpose of an ER diagram in database design
The entity relationship (ER) diagram is the graphical representation technique used to depict a data model. Each entity in a ER diagram is named in the singular noun form such as Customer rather than Customers. The labeled line connecting two entities describes the nature of the association between them. This association is represented with a verb such as shipped, requests, or receives. The ER diagram also represents cardinality (the degree of association between two entities). Four basic forms of cardinality are possible: zero or one (0,1), one and only one (1,1), zero or many (0,M), and one or many (1,M). These are combined to represent logical associations between entities such as 1:1, 1:0,M, and M:M.
You might also like to view...
Xtra Company purchased a business from Argus for $96,000 above the fair value of its net assets. Argus haddeveloped the goodwill over 12 years. How much would Xtra amortize the goodwill for its first year?
a. not enough information to calculate amortization b. $7,000 c. $8,000 d. goodwill is not amortized
To evaluate their sources, researchers should check publication dates and the authors' credentials and methods
Indicate whether the statement is true or false
Spicy Salsa, Inc, complains to the Federal Trade Commission (FTC) about an ad broadcast by Tangy Taco Sauce Company, Spicy Salsa's competitor. The FTC investigates and concludes that the ad is deceptive. The FTC's next step is to A) conduct negotiations between the competitors
B) draft a formal complaint. C) issue a cease-and-desist order. D) permit Spicy Salsa to broadcast similarly deceptive counteradvertising.
All of the following are benefits from organizing related items into product lines EXCEPT:
A. package uniformity B. varying quality C. advertising economies D. efficient sales and distribution E. standardized components