You are building a purchase management system for company XY…
You are building a purchase management system for company XYZ. The company has several vendors and purchase orders. Each vendor has several purchase orders or none and each purchase order is assigned to one vendor. Which of the following diagrams best represents this scenario?
Read DetailsIn a company, each sales rep is assigned to one customer, bu…
In a company, each sales rep is assigned to one customer, but could be unassigned if she or he has just joined. On the other hand, every customer is always assigned one sales rep. Which of the following diagrams is consistent with this description? Choose only one.
Read DetailsThe diagram below captures the situation where each home cou…
The diagram below captures the situation where each home could engage several contractors for work (like plumbing, roofing, electrical, etc) and each contractor could be working on several homes. On the left are several attributes. Match each of them to appropriate entity types on the right. More than one attribute can map to a given entity type, and therefore some items on the right might remain unmatched.
Read DetailsEach of the following four descriptions mentiones two entity…
Each of the following four descriptions mentiones two entity types. Let us refer to the first entity type mentioned in each description as A, and the second entity type mentioned as B. For example, if the description stated ” We have several customers (A), and store an id, name and address for each customer. We have several cars (B), and store an id, vin_no, make and model for each. Each car can belong to at most one customer and each customer can have zero or many cars.” In this example, we mentioned Customers first and hence that entity type would be referred to as A and Cars would be referred to as B. Let ua assume that we draw four separate entity relationship diagrams, one for each description. Which of the descriptions will result in a foreign key occurring in entity type A? You have to select all the correct answers. No partial credit. You will get credit only if you choose all the correct choices and none of the incorrect ones.
Read Details