Database design and development Assignment Sample
20 Pages5246 Words146 Views
Added on 2021-01-02
Database design and development Assignment Sample
Added on 2021-01-02
ShareRelated Documents
DATABASE DESIGN ANDDEVELOPMENT
Table of ContentsINTRODUCTION...........................................................................................................................1PART 1............................................................................................................................................11. Requirements of system and users ....................................................................................1P1 ...........................................................................................................................................22. Design of database .............................................................................................................23. Understanding user and system requirements....................................................................34. Analysing effectiveness of database wrt system and user requirements............................4PART 2............................................................................................................................................4Completely functional database system.................................................................................4P2............................................................................................................................................4Effectiveness of database solution and suggestions for future improvement .................................7Database effectiveness in relation with the prescribed requirements....................................7Database effectiveness in relation with requirements of user................................................8Future improvement strategies for sustaining effectiveness..................................................8PART 3............................................................................................................................................9Effectiveness of database testing............................................................................................9P4..........................................................................................................................................10Test data choice in effectiveness of testing..........................................................................11Test plan ..............................................................................................................................13PART 4..........................................................................................................................................13P5..........................................................................................................................................13Technical and user documentation for the developed database system ..............................13CONCLUSION..............................................................................................................................16REFERENCES..............................................................................................................................17
INTRODUCTIONDesigning of database refers to the fact of involving every essential feature that isrequired by the organisation. Elements are to be verified carefully at the time of designing of thedatabase as it should be in an order to achieve the specific requirements of a firm (Jagadish andet.al, 2016). Also, after the database has been successfully designed, its implementation takesplace when the specified database is being implemented in the company so that it can help themto attain their objectives at a much faster time. The report is about analysing the user and systemrequirements of the organisation. It also involves the effectiveness of design of the databasecovering system and user requirements. A well and fully functional database has also beendesigned in the report. Also, the report involves testing of the requirements and a properdocumentation for user as well as technical measures. PART 11. Requirements of system and users There are some factors that are causing issues with the manual processing of routinefunctions of hospital So, in order to overcome the issue, the business has decided to choose awell designed database through which they can record necessary information and tracks of theiractivities. This will help them to focus on achieving a great productivity with minimum error andtrust of their patients. Therefore, there must be some user as well as system requirements for thisdatabase as well. Some well known example of user requirement can be that hospital deals with avariety of information management such as keeping track of details related to their patients,schedules and information of doctors, purchasing slips related to medicines and otherequipments. So, recording a proper set of information about all case studies of their facilityseekers and service providers is required to be maintained. These should be integrated with termssuch as parameters like blood groups and other related parameters used in hospitals. Therefore,these should be kept in mind while the designing of database. Also, system requirements can bethat the systems on which they will implement database should be up to date, whether it is interms of software or of hardware, both of these should be well developed so that the databasemay not create any issue on the system such as heating up of system, hanging etc. These usersand system requirements are necessary to be ensured while the designing as well asimplementation of the database so that they can help them to achieve their objectives in a mostefficient manner.
P1 2. Design of database
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
Database Design & Development - Doclg...
|17
|3973
|479
Database Design & Development Assignmentlg...
|25
|6575
|323
Database Assignment 2022lg...
|101
|18699
|18
Database Design & Development- Doclg...
|31
|5788
|349
Data Modelling Assignmentlg...
|15
|2960
|83
Database Design and Developmentlg...
|27
|3992
|59