Question: 3.4 A vendor builds multiple types of tablet computers. Each type has a type identification number and a name. The key specifications for each

3.4 A vendor builds multiple types of tablet computers. Each type has a type identification number and aExpress the relationships in the above description graphically with an E-R diagram Note: There are 3 entities

3.4 A vendor builds multiple types of tablet computers. Each type has a type identification number and a name. The key specifications for each type include amount of storage space and display type. The company uses multiple processor types, exactly one of which is used for a specific tablet computer type; obviously, the same processor can be used in multiple types of tablets. Each processor has a manufacturer and a manufacturer's unique code that identifies it. Express the relationships in the above description graphically with an E-R diagram 3.5 The loan office in a bank receives from various parties requests to investigate the credit status of a customer. Each credit request is identified by a Request ID and is described by a Request Date and Requesting Party Name. The loan office also received results of credit checks. A credit check is identified by a Credit Check ID and is described by the Credit Check Date and the Credit Rating. The loan office matches credit requests with credit check results. A credit request may be recorded before its result arrives; a particular credit result may be used in support of several credit requests. Draw an ERD for this situation. (1) Express the relationships in the above description graphically with an E-R diagram (2) Now, assume that credit results may not be reused for multiple credit requests. Redraw the ERD for this new situation using two entity types Express the relationships in the above description graphically with an E-R diagram Note: There are 3 entities in this question. You should draw them in ONE ER diagram, such as the following diagram (Note: this is just an example to show the final diagram). Item 1 Item 2 Item 3 Entity 1 Item 1 Item 2 Item 31 Entity2 Item 1 Item 2. Item 3 Entity3

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!