New Era is a manufacturing company that has two types of suppliers. The first type of suppliers allow credit and the second type of suppliers insist on payment in cash before delivery. The manufacturer wants to maintain information on these two types of suppliers separately. For the credit suppliers, “credit period” and “credit limit” have to be recorded. For the cash suppliers, “date of payment” needs to be stored. John is the database administrator at New Era. He needs to draw an E/R diagram to represent the above situation. . | Lesson id EXPERIMENT Relational Database Design Relational Database Design Lab Exercises Exercise 1 New Era is a manufacturing company that has two types of suppliers. The first type of suppliers allow credit and the second type of suppliers insist on payment in cash before delivery. The manufacturer wants to maintain information on these two types of suppliers separately. For the credit suppliers credit period and credit limit have to be recorded. For the cash suppliers date of payment needs to be stored. John is the database administrator at New Era. He needs to draw an E R diagram to represent the above situation. Jnote Instructor Notes Solution Exercise 2 Ron Floyd is the newly appointed database administrator at Standard bank. The management of this bank wants to computerize the process of banking. According to the bank s policy one customer can have many accounts but one account cannot be shared by many customers. As the first activity in database design Ron is required to Relational Database .
