QUESTION: USING A SUITABLE EXAMPLE (SYSTEM OF YOUR OWN) EXPLAIN DATABASE SYSTEM DEVELOPMENT LIFE CYCLE.<\/p>\n
I will use a Hospital database system as an example<\/p>\n
Life Cycle<\/p>\n
This stage is integrated with the overall Information System strategy of the organization. This includes the objectives and purpose of the system.<\/p>\n
The major aim of our hospital database is to keep the records of the patients enrolled so that they can view the information such as health records and the medical charges.<\/p>\n
In the systems definition phase, the scope and boundaries of the database application are described and the major users of the database such as links with other information systems is described.<\/p>\n
Our hospital database system will be linked with the finance system and the patients record system. The users will be administrators, staff and patients.<\/p>\n
Information about a part of organization to be supported by the database system is collected.<\/p>\n
The data to be used in our hospital database system includes patient\u2019s and staff details and the data generated is patient\u2019s health records.<\/p>\n
Phase 1: Conceptual Database Design<\/p>\n
Process of constructing a model of the data used independent of all physical consideration.<\/p>\n
In our system the conceptual data model is built using the information in administrators, staff and patients\u2019 requirements specification.<\/p>\n
Phase 2: Logical Database Design<\/p>\n
The model of the data to be used is based on a specific data model but independent of a Database Management System.<\/p>\n
Our system is based on the target data to be relational data model.<\/p>\n
Phase 3: Physical Database Design<\/p>\n
Here we create the description of the implementation of the database on secondary storage.<\/p>\n
In our hospital system we will use tables and the data types are as follows<\/p>\n
Patient\u2019s name, age ,sex and status.<\/p>\n
This is where we select the database system to use I . e MySQL, MS Access, e.t. c<\/p>\n
In our system we will use MySQL<\/p>\n
This is where the actual database is created.<\/p>\n
This is the process of running the system to find errors in the database.<\/p>\n
In our system if we find errors, we shall correct them.<\/p>\n
Process of monitoring and maintaining database system upon installation.<\/p>\n
We will observe the performance of the hospital system such as when a patients enters their name, sex, status and age it should display the personal information.<\/p>\n
<\/p>\n
<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
DATABASE SYSTEM DEVELOPMENT LIFE CYCLE QUESTION: USING A SUITABLE EXAMPLE (SYSTEM OF YOUR OWN) EXPLAIN DATABASE SYSTEM DEVELOPMENT LIFE CYCLE. I will use a Hospital database system as an example Life Cycle Database Planning This stage is integrated with the Read More …<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[],"class_list":["post-435873","post","type-post","status-publish","format-standard","hentry","category-essay-paper-writing"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/435873","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=435873"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/435873\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=435873"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=435873"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=435873"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}