Specify the information-Requirements of the credit card approval database system in simple English. (PLEASE SOLVE FULLY) Draw
Question:
Specify the information-Requirements of the credit card approval database system in simple English. (PLEASE SOLVE FULLY)
Draw an E-R schema (diagram) that satisfies all the requirements you have specified in detail in the first step. Do not use any automated tools. Your ER diagrams should be hand-drawn Your E-R diagram (schema) should include at least two out of three of the following constructs: (1) ISA relationships, (2) weak entity types, and (3) relationship types defined on a single entity type – recursive relationship types. If it does not, modify your original “Requirements Specifications” so that it does.
Entities should include Credit Card Entity, Application Entity, Consumer Entity, Limits Entity, Document Entity and two or 3 more.
After that, Design 6 queries on the E-R schema (diagram) that you have drawn in the second step. 2 of the queries should be answered by scanning a single Entity Type. 2 of the queries should involve two Entity Types. 2 of the queries should involve three Entity Types. For each query, define the query in English. (e.g. what does it retrieve?) and specify how it can be implemented in an algorithmic manner.