Address each of the following: (a) Describe the major activities performed during the Database Design phase of the database life cycle (DBLC). (b) Discuss how the DBLC activities in this phase align with other activities in the software development life cycle (SDLC). (c) Explain how the activities in the Database Design phase contribute to the next phase of the next DBLC phase—Implementation and Loading.

Address each of the following: (a) Describe the major activities performed during the Database Design phase of the database life cycle (DBLC). (b) Discuss how the DBLC activities in this phase align with other activities in the software development life cycle (SDLC). (c) Explain how the activities in the Database Design phase contribute to the next phase of the next DBLC phase—Implementation and Loading.

Database Systems: Design, Implementation, & Management

12th Edition

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Carlos Coronel, Steven Morris

Chapter9: Database Design

Section: Chapter Questions

Problem 5P

See similar textbooks

Similar questions

The conceptual data model is the set of concepts that A. Describes the structure of a database and the associated retrieval transactions. B. Describes the structure of a database and the associated retrieval and update instructions. C. Is the actual implementation of the database, using a commercial DBMS. D. Describes the structure of a database and the associated insert and update transactions.
Computer Science Case: 1) A very famous example in real life about database system would be "Hospital Management system" 2) Problems in the business process without database system approach: - Redundant data : Managing so much of redundant data in a hospital would be tough without DBMS - Memory management : Without DBMS, managing the whole memory would be quite tough - Managing shared data - Managing the access control 3) Stages in Database System Development Life Cycle: - Stage 1: Area selection and problem definition : Defined the problem as "Hoepital management system" - Stage 2: Gathering data : Gathering data through various sources in the hospital - Stage 3: Creating alternatives : If any - Stage 4: Feasibility study : Studying how feasible this plan is. - Stage 5: Development plan : Planning the whole development procedure - Stage 6: Equipement evaluation - Stage 7: Design & development : Actual development - Stage 8: Testing : Final testing - Stage 9:…
A small training college has decided to extend and replace its existing database system. The project has received board approval and the required functional changes and additional requirements have been agreed with the users. A project manager has been appointed and has been allocated a project team of three database analysts, three development programmers and one tester, with selected users being made available for acceptance testing. An outline project schedule for the development and implementation phases has been drawn up. It includes the following tasks and related staff allocations. Task Description Duration (weeks) Staff A Define required new database functionality 4 Database Analyst DA1 B Define new data entry and update requirements 3 Database Analyst DA2 C Define new data analysis and report outputs 3 Database Analyst DA3 D Define database transfer rules 2 Database Analyst DA3 E Code and test extended database tables…
QUESTION 2 a) Application design involves transaction design and user interface design. Describe the purpose and main activities associated with each. b) What is the difference between the prototyping approach and the database systems development lifecycle? c) Discuss the main activities associated with the implementation stage of the database system development lifecycle.
The National Science Foundation (NSF) is a significant funder of academic research in the United States. Researchers submit proposals to various programs (for example, the “INFO INTEGRATION & INFORMATICS” (III) program in the the “Computer Science Engineering” (CSE) directorate is primarily responsible for funding research on database systems.) Panels of peer reviewers (other academics in related fields) decide which proposals will be funded, and there are some managers in NSF that are managing the funds. Once the grants are awarded, the university (Organization) administers them on behalf of the researchers. These grants typically range from $50,000 to millions of dollars, and they are used by researchers to pay graduate students, postdocs, and staff, acquire equipment and supplies, and cover expenses like travel. It is important that each grant have a PI that known as the owner of the grant and he/she is a researcher in that organization. Given the vast number of grants awarded…
database designers define the required data structures, types and Having knowledge of number of entities as well as the physical size of the database? a. Database objectives b. Database problem c. Database design constraints d. Database design scope
I understand the purpose of a database, which is to make data record-keeping easier for any company. And I'm aware of the hardware requirements. The concept of programming the rules and structure of a database is the area in which I am most confused. A database, in my mind, is a chart (or many charts) containing fields that are used to hold records. Then, of course, those records in one chart interweave with those in other charts, necessitating the creation of chart linkages. The concept of developing a framework for the data to fit into is where I get stuck. Are we creating metaphysical venues to store data, or are we just recording relationships between data saved on a variety of platforms?
Research and investigate the following scenarios. Include an analysis by providing arguments or counter-arguments and examples where necessary:a) How do older file systems and the database approach differ in terms of the relationship between the data and the application programs?b) What is meant by the term ‘weak entity’? Why is it not possible to represent a many-to-many relationship with two tables?c) Explain what is meant by transactions in the context of a database and why they are needed. Describe the facilities that a DBMS should provide for the support of transactions.
A) Draw a block diagram of the component modules of a database management system (DBMS) and their interactions. ite the n
1b)By using a scenario, explain program-data dependence issue found in previous database technologies such as file-oriented database before relational database model was introduced.
Research and investigate the following scenarios. Include an analysis by providing arguments or counter arguments and examples where necessary: a) How do older file systems and the database approach differ in terms of the relationship between the data and the application programs?b) What is meant by the term ‘weak entity’? Why is it not possible to represent a many-to-many relationship with two tables?c) Explain what is mean by transactions in the context of a database and why they are needed. Describe the facilities that a DBMS should provide for the support of transactions.
Answer both questions