The company selling 2nd hand vehicles has branches in different cities. In each branch employees work...

 

Transcribed Image Text:

The company selling 2nd hand vehicles has branches in different cities. In each branch employees work in different positions. Monthly reports including "from whom", "when" and "price" information are produced for bought vehicles. Similar reports are produced for sold vehicles. Up to now, only commercial vehicles and automobiles are sold but they are planning to sell also heavy construction vehicles in near future. Branches may organize campaign individually or together with others for commercial vehicles. In all type of vehicles additional 5% reduction will be considered when 2 vehicles are bought by customers. If customers request the repairment history report for any vehicles, it will be provided. a. Define entities, their attributes with type (optional, mandatory, UID). Explain the reasons for selection of the type. You can add the attributes to entities which are not explained here. (10 p) b. Define matrix diagram for the entities (10p) c. Give an example for procedural rule for above business (5 p) Draw Entity Relationship Diagram (ERD) for above scenario and display followings in this diagram. d. Define relationship between these entities specifying (optionality, cardinality and name). Explain the reasons for selection of optionalities and cardinalities. (10 p) e. Display an example for non-transferrable relationship for above business. (5 p) f. Display an example for supertype-subtype structure for above business. (10 p) g. Display an example for M:M relationship for above business and resolve it. (10 p) The company selling 2nd hand vehicles has branches in different cities. In each branch employees work in different positions. Monthly reports including "from whom", "when" and "price" information are produced for bought vehicles. Similar reports are produced for sold vehicles. Up to now, only commercial vehicles and automobiles are sold but they are planning to sell also heavy construction vehicles in near future. Branches may organize campaign individually or together with others for commercial vehicles. In all type of vehicles additional 5% reduction will be considered when 2 vehicles are bought by customers. If customers request the repairment history report for any vehicles, it will be provided. a. Define entities, their attributes with type (optional, mandatory, UID). Explain the reasons for selection of the type. You can add the attributes to entities which are not explained here. (10 p) b. Define matrix diagram for the entities (10p) c. Give an example for procedural rule for above business (5 p) Draw Entity Relationship Diagram (ERD) for above scenario and display followings in this diagram. d. Define relationship between these entities specifying (optionality, cardinality and name). Explain the reasons for selection of optionalities and cardinalities. (10 p) e. Display an example for non-transferrable relationship for above business. (5 p) f. Display an example for supertype-subtype structure for above business. (10 p) g. Display an example for M:M relationship for above business and resolve it. (10 p)

Answer rating: 100% (QA)

a Entities Branch a physical location where the company sells vehicles Attributes Branch ID UID a unique identifier for each branch Branch name mandatory the name of the branch Branch address mandator... View the full answer