Question: 1. Explain the difference between conceptual, logical, and physical database design. Why might these tasks be carried out by different people? a. What is the

 1. Explain the difference between conceptual, logical, and physical database design.

1. Explain the difference between conceptual, logical, and physical database design. Why might these tasks be carried out by different people? a. What is the difference between a homogeneous and a heterogeneous DDBMS? Under what circumstances would such systems generally arise? 2. What factors are important in a DBMS software selection? a. What three levels of backup may be used in database recovery management? Briefly describe what each of those three backup levels does. Shred gumery 3. Explain the difference between a distributed database and distributed processing sotwerad dis he a. Assume that your company has assigned you the responsibility of selecting the corporate DBMS. Develop a checklist for the technical and other aspects involved in the selection process. 4. Describe the main aims and phases of the CRISP-DM model a. Discuss what is meant by the following terms when describing the characteristics of the data in a data warehouse: (a) subject-oriented; (b) integrated; (c) time-variant; (d) non-volatile. 5. How would you identify entity and relationship types from a user's requirements specification? a. Discuss why you would want to validate a conceptual data model and describe two approaches to validating a conceptual model. 6. Identify the benefits of using replication in a distributed system. a. Discuss how mobile database support the mobile worker

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 Databases Questions!