Loan Star Credit Services Inc. (LSCS) receives from various parties requests to investigate the credit status of customers. Each credit request is identified by a Request_ID and is described by a Request_Date, Requesting_Party_Name, and Request_Period (whose value is derived by the request date and current date). LSCS also receives results of credit checks. Each credit check is identified by a Credit_Check_ID and is described by Credit_Check_Date and Credit_Check_Result. LSCS associates each credit request with a credit check. Each credit check result may be used in support of one to many credit requests. A credit request may be recorded before its credit check date. Draw an entity-relationship diagram (ERD) for this situation using the Crow's foot notation introduced in class. You may download and modify this template file (using Draw.io site Links to an external site.; click "File > Open from > Device ..." and navigate to the file you downloaded) for your drawing in this part, then export an image from your modified drawing, and insert the image into your file (do not take a screenshot of your diagram but export it by choosing "File > Export as > PNG ..."). Please include a written description nearby your inserted image. Now, assume that each credit result may only be used for one credit request. Draw a new ER diagram (based on description in Part 1) to incorporate this new information by using the same number of entity types as in Part 1. You may download and modify this template file (using Draw.io site Links to an external site.; click "File > Open > Device ..." and navigate to the file you downloaded) for your drawing in this part, then export an image from your modified drawing, and insert the image into your file (do not take a screenshot of your diagram but export it by choosing "File > Export as > PNG ..."). Please include a written description nearby your inserted image. Draw a new ER diagram by using only one entity type to combine the entity types described in Part 2. Your ERD should represent the same information as described in Part 2. You may download and modify this template file (using Draw.io site Links to an external site.; click "File > Open > Device ..." and navigate to the file you downloaded) for your drawing in this part, then export an image from your modified drawing, and insert the image into your file (do not take a screenshot of your diagram but export it by choosing "File > Export as > PNG ..."). Please include a written description nearby your inserted image.

Loan Star Credit Services Inc. (LSCS) receives from various parties requests to investigate the credit status of customers. Each credit request is identified by a Request_ID and is described by a Request_Date, Requesting_Party_Name, and Request_Period (whose value is derived by the request date and current date). LSCS also receives results of credit checks. Each credit check is identified by a Credit_Check_ID and is described by Credit_Check_Date and Credit_Check_Result. LSCS associates each credit request with a credit check. Each credit check result may be used in support of one to many credit requests. A credit request may be recorded before its credit check date. Draw an entity-relationship diagram (ERD) for this situation using the Crow's foot notation introduced in class. You may download and modify this template file (using Draw.io site Links to an external site.; click "File > Open from > Device ..." and navigate to the file you downloaded) for your drawing in this part, then export an image from your modified drawing, and insert the image into your file (do not take a screenshot of your diagram but export it by choosing "File > Export as > PNG ..."). Please include a written description nearby your inserted image. Now, assume that each credit result may only be used for one credit request. Draw a new ER diagram (based on description in Part 1) to incorporate this new information by using the same number of entity types as in Part 1. You may download and modify this template file (using Draw.io site Links to an external site.; click "File > Open > Device ..." and navigate to the file you downloaded) for your drawing in this part, then export an image from your modified drawing, and insert the image into your file (do not take a screenshot of your diagram but export it by choosing "File > Export as > PNG ..."). Please include a written description nearby your inserted image. Draw a new ER diagram by using only one entity type to combine the entity types described in Part 2. Your ERD should represent the same information as described in Part 2. You may download and modify this template file (using Draw.io site Links to an external site.; click "File > Open > Device ..." and navigate to the file you downloaded) for your drawing in this part, then export an image from your modified drawing, and insert the image into your file (do not take a screenshot of your diagram but export it by choosing "File > Export as > PNG ..."). Please include a written description nearby your inserted image.

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

Loan Star Credit Services Inc. (LSCS) receives from various parties requests to investigate the credit status of customers. Each credit request is identified by a Request_ID and is described by a Request_Date, Requesting_Party_Name, and Request_Period (whose value is derived by the request date and current date). LSCS also receives results of credit checks. Each credit check is identified by a Credit_Check_ID and is described by Credit_Check_Date and Credit_Check_Result. LSCS associates each credit request with a credit check. Each credit check result may be used in support of one to many credit requests. A credit request may be recorded before its credit check date. Draw an entity-relationship diagram (ERD) for this situation using the Crow's foot notation introduced in class. You may download and modify this template file (using Draw.io site Links to an external site.; click "File > Open from > Device ..." and navigate to the file you downloaded) for your drawing in this part, then export an image from your modified drawing, and insert the image into your file (do not take a screenshot of your diagram but export it by choosing "File > Export as > PNG ..."). Please include a written description nearby your inserted image.
Now, assume that each credit result may only be used for one credit request. Draw a new ER diagram (based on description in Part 1) to incorporate this new information by using the same number of entity types as in Part 1. You may download and modify this template file (using Draw.io site Links to an external site.; click "File > Open > Device ..." and navigate to the file you downloaded) for your drawing in this part, then export an image from your modified drawing, and insert the image into your file (do not take a screenshot of your diagram but export it by choosing "File > Export as > PNG ..."). Please include a written description nearby your inserted image.
Draw a new ER diagram by using only one entity type to combine the entity types described in Part 2. Your ERD should represent the same information as described in Part 2. You may download and modify this template file (using Draw.io site Links to an external site.; click "File > Open > Device ..." and navigate to the file you downloaded) for your drawing in this part, then export an image from your modified drawing, and insert the image into your file (do not take a screenshot of your diagram but export it by choosing "File > Export as > PNG ..."). Please include a written description nearby your inserted image.
Write a brief desription (≤ 50 words) to answer these questions: Which ERD (in Part 2 or Part 3) do you prefer? Why?

I included what the downloaded Draw.io looks like.