The proposal is certainly feasible and possible because a relational database such as MySQL can easily handle the data storage and retrieval complexity required, PHP can be used to facilitate data entry and retrieval, and the use of CSS can help to ensure consistency in the…
For example, if a patients current condition is required to be known, then all the necessary particulars of the patient will be required along with details of the treatments given, the response of the treatments and general health progress.
1. A foreseeable challenge could be that the number of patients will grow over time. It is therefore essential to minimise data redundancy and lack of coherency issues at the design stage through normalisation and ensuring that relationships between the relational tables are clearly and appropriately defined. This will ensure the database can cope well with the increase over time instead of becoming too complex to handle.
2. It is of the utmost importance to ensure that health care workers have not only all the required information presented to them about each patient when requested, but also that the information is up-to-date and provided in real-time. This is to ensure that no important decision is taken by a health care worker at the centre based on old information or historical data that is no longer valid.
Although not directly related to database design, another feasibility issue that could impact on how well the design is implemented and how many essential design features are incorporated, is the budget. The MySQL software itself will be free, but the development costs and the cost of the hardware need to be considered. In case the budget is tight then a distinction should be drawn between the most essential elements and features, and extras that can be down without, at least for now. Besides cost, another major constraint is time. The health care centre management must ensure they can have the database developed within the time they have available before it will be required to be ...
Cite this document
(“Database Design Proposal: Analysis Essay Example | Topics and Well Written Essays - 750 words”, n.d.)
Retrieved from https://studentshare.net/logic-programming/582647-database-design-proposal-analysis
(Database Design Proposal: Analysis Essay Example | Topics and Well Written Essays - 750 Words)
“Database Design Proposal: Analysis Essay Example | Topics and Well Written Essays - 750 Words”, n.d. https://studentshare.net/logic-programming/582647-database-design-proposal-analysis.
The primary entity in the validations information model is the meter assigned to the customer, as this is a unique entity for every customer. The meter assigned to the domestic customers in the market not only provides the flexibility for the organization to effectively identify the customer and his/her consumption but also provides the ability for the company to conduct regular maintenance on the meters so as to prevent any malfunctioning and abuse of the facility provided to the customers.
When any damage to this business resource occurs then the whole business can go down or may function improperly. Through seeing this huge development in technology and its potential advantages to the business “Mayo Clinic Medical
The proposal is being carried out to come up with an easy-to-use, fast, secure and reliable system to safeguard health information in the organization. The author of this research also proposes a system that is cheap to design and easy to maintain. The tool used for the database management will be SQL.
It also has a limitation while indicating the relationships among the data entities.
This diagram can be highly improved so that it illustrates clearly all the relationships. This can only be achieved through the use of the
The unit has enabled me gain substantial knowledge on design and management of database.
The course gives a detailed introduction of database design. The introduction to database design gave me in-depth