Databases Assignment Solved

4 Pages1134 Words102 Views

Added on 2021-06-16

Databases Assignment Solved

Added on 2021-06-16

BookmarkRelated Documents

REFLECTION PORTFOLIO: DATABASES (WEEKS 6, 7 AND 8)1Reflection Portfolio: Databases (Weeks 6, 7 and 8)NameDate

REFLECTION PORTFOLIO: DATABASES (WEEKS 6, 7 AND 8)2Week 6The team was interested in how software systems and computers work and how they are developed, especially databases given many software systems are now database driven (Buytaert, 2015) and since we were supposed to develop a database to be used in the emergency room (ER). Week six material gave us an opportunity to learned about the concept of database development through a technique known as normalization, a novel concept that we were able to apply in developing the database; we had imagined that all one needed was the database development languages and how to use it, then they were set. However, the week’s course has exposed me and my group to new approaches and concepts, more importantly, the concept of normalization in whichdatabase development commences by observing the relationships between attributes (Mahjourian, 2015; Diaz, Lovelle, & Garcia-Bustelo, 2014, p.245). We did have an idea that someone’s ID in the ER must be linked to their address, first and second names, phone number, and type of job but did not know how to create these linkages. The greatest lesson obtained from the week was how to use the normalization technique for testing using normal form tests to help in identifying how the various attributes can be grouped optimally. Having acquainted ourselves well with the concept of data redundancy minimization and how this is achieved using base tables, we managed to logically come up with the relationships in a way that reduced update anomalies. Further the concept of functional dependencies and transitive dependency and their role in normalization. Using the lessons learned, we were was able to create relationships between attributes and their functional dependencies in designing an ER (emergency room) database Week SevenIn this week, the course content was on logical database design and entity relationship modeling. After determining the relationships between elements using normalization, the database must be designed in a logical manner in which data is arranged into logical relationships of entities and attributes. In this week, having learned and understood what is actually contained in a database and how it operates based on relationships we were able to apply these in creating the E-R diagramsin a logical way based on the normalization process. Before the week, our understanding of E-R diagrams was at best abstract ; we understood that the information would be held in the database buthad no idea exactly how this is achieved . With a clear understanding of the type of information found in a database (the entity) and how the uniqueness of the entity is defined using attributes, we managed to build E-R diagrams between the different elements (the worker, patient, shift, admission, the bed to use, their prescribed medicines and the attributes of these elements. Just like in building a house where a blue print is used, the use of E-R diagrams creates the blue print on howthe database is designed ('Visual Paradigm', 2018). Apart from learning the concept of creating

End of preview

Want to access all the pages? Upload your documents or become a member.

Database Design and Implementation: ER-Model, Relational Schema, Constraints, and Business Intelligence

|1023

|448

Database System Design

|733

|305

ER Diagram and Normalization for Hotel Booking Management System

|833

|461

Database Design for Emergency Room Case Study

|1316

|357

Database Concepts

|633

|295

Database Implementation

|38

|5094

|79

Databases Assignment Solved