Question: Urgent answers needed immediately please a. Explain how database solves the problem of data redundancy, limited sharing and security in an organization's business processes [5

Urgent answers needed immediately please a.

Urgent answers needed immediately please

a. Explain how database solves the problem of data redundancy, limited sharing and security in an organization's business processes [5 marks] b. How would you model a system that allow patients to be tested by physicians for presence of covid-19 symptoms? [5marks] c. Explain the concept of business rule in a database [3 marks] d. As a software developer, explain how SDLC and Prototyping would be use in Developing a school management system. [12 marks] e. Using examples, explain when would a developer employ any of the three types of entity in a data model [6 marks] f. Explain the four common basic building blocks on which data models are built? [8 marks] g. Discuss the integrity rules which are enforced during database design [5 marks] h. When do we apply EER model and ER model in a data model? [4 marks] i. A bank has three types of accounts: checking, savings, and loan. Following are the attributes for each type of account: CHECKING: Acct No, Date Opened, Balance, Service Charge. SAVINGS: Acct No, Date Opened, Balance, Interest Rate. LOAN: Acct No, Date Opened, Balance, Interest Rate, Payment. Assume that each bank account must be a member of exactly one of these subtypes. i. Explain Generalization and Specialization [4 marks] ii. Using generalization, develop an EER model segment to represent this situation and indicate super type and subtype. Show the subtype discriminator [10 marks] iii. State three importance of ER and EER model diagram [4 marks]

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 General Management Questions!