Free

Database design - Essay Example

Comments (0) Cite this document
Summary
A database system is a worthy asset of any business organization. As such its administration should be effective. For one to ensure effective database management and…
Download full paperFile format: .doc, available for editing
GRAB THE BEST PAPER93.5% of users find it useful
Database design
Read TextPreview

Extract of sample "Database design"

Database design: The database design is a very critical unit for any individual who has interest in the computer technology field. A database system is a worthy asset of any business organization. As such its administration should be effective. For one to ensure effective database management and administration, one need to fully understand the database design. 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 understanding of how the idea of database originated from. From the introduction, I learned that the idea of database management system arose as a result of the unending complexities associated with managing data using spreadsheet. Though the spreadsheet enables on to store various data, it is difficult to manage it because the data in different sheets are disjointed (Brathwaite, 2012). The spreadsheets do not a have tools which enables data which are related to be linked.
I also learned about database management systems. These are software package or a set of programs that are used by the people to interact with the database system. These packages were developed because managing the database is a complicated and inherent task. The DBMS enable complete manipulation of the underlying database. The diagrams representing the interaction between the programs, user, database and database management system enabled me to internalize the database design concept. Considering the strength and weaknesses of the database, I realized that database system is inherently important to any organization which uses a computerized system. The advantages outdo the disadvantages by far. The henry books database case is an ideal case study for database design. It provides all the information required in designing a database system.
The course also introduced me to relational databases and different low level programming features such as Query-By-Exam (QBE), simple and compound query criteria, database fields, tables and functional. All these are programming features used when designing and developing a database system. I also learned about different features used in manipulating data in the database system. These include and not limited to co sorting, joining tables, the use of update query statements, make table query, delete-table query, select, project data select and normal sets. The case study gave detailed illustrations of these database features.
The course also introduced me to Structured. This is a machine level language which enables the user to retrieve specific information from the database rather than displaying the whole table. The SQL assist in encapsulation and data hiding. The commands or SQL statement can also be used to create, edit, update and manipulate data in a relational database. In addition the course introduces different types of database such as MySQL, Oracle, MS access and SQL server. I learned various programming techniques used to develop a database system (Brathwaite, 2012).
Finally, the learned about database administration which is the management of database activities. This entails roles of a database administrator in both work station and server environment. The DMA’s responsibilities in coming up with access privileges and database user policies are also explained. The formulation of access privileges are also dealt with in details. I realized that database policies are critical in ensuring security and appropriate use of database. These policies include security, archiving, disaster management and access privileges.
Generally, the course is very crucial for people who want to be database administrators. It gives lengthy and detailed exploration of database design concept. In fact, anyone who does this course will find the database design technology inherently simple.
References
Brathwaite, K. (2012). Object-oriented database design: Concepts and Application. Acad. Press. Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Database design Essay Example | Topics and Well Written Essays - 500 words”, n.d.)
Database design Essay Example | Topics and Well Written Essays - 500 words. Retrieved from https://studentshare.org/information-technology/1619582-database-design
(Database Design Essay Example | Topics and Well Written Essays - 500 Words)
Database Design Essay Example | Topics and Well Written Essays - 500 Words. https://studentshare.org/information-technology/1619582-database-design.
“Database Design Essay Example | Topics and Well Written Essays - 500 Words”, n.d. https://studentshare.org/information-technology/1619582-database-design.
  • Cited: 0 times
Comments (0)
Click to create a comment or rate a document

CHECK THESE SAMPLES OF Database design

How the Homeric Hymn on Aphrodite Defines the Power of the Goddess

4 Pages(1000 words)Term Paper

Database Design

...Database Design The database design is presented in three stages as identified by Gavin Powell (2005)i. These include Conceptual Design, Logical Design and the Physical Design as described below. Conceptual Design The conceptual design of a database being the element part of the overall development of the design forms a critical segment of the design process. The conceptual design stage of the database predominantly includes the description of the various entities and their relationship with regards to...
14 Pages(3500 words)Essay

Relational Database Design

...Relational Database Design The Design of a Relational Database by This paper describes the process of creating a relational database. Itincludes the SQL code (MySQL) for creating the tables, the joins to create the necessary relationships and the results of those SQL runs. It describes the specifications of the proposed system, the logic of that system, the table definitions and contents, a live transaction which inserts data and one that deletes it and finally a non-trivial query which demonstrates multiple joins, group functions, qualifiers and correlation variables. Relational Database Design The hallmark of the relational database is that when one table changes in the database all other tables are updated and are current. 1... ...
6 Pages(1500 words)Assignment

Database Design & Development

...Relational Database Management System Definition of RDBMS RDBMS can be defined as a set of modules that helps the organization create, maintain database at a single, centralized point. It is a database management system that is based on a popular model of relational model. This model was devised by E. F. Codd. It is a DBMS that manages the data in the form of tables, even the relation that exists between these tables in stored in the form of tables. RDBMS is based on the concept of relational system, referential integrity and normalization (Chaterjee 2005). All data is held in the form of tables and is described by the use of data values. The data which is found in the table columns...
4 Pages(1000 words)Essay

Database Design and Implementation

...Database Design and Implementation Faculty: Department: Module Academic Year: Semester Data investigation and capture 1 of the three websites chosen 1.1.1 http://www.ubid.com This is an online auction site gaining popularity close to that of e-bay. Even though it does not have as much traffic as e-bay, it generates quite a number of sales. The fact that it does not charge listing fee puts it at a greater competitive edge over the similar online purchasing sites. A major pitfall exists in the payment duration; the buyer’s payment can take up to a fortnight since it goes through Ubid which can cause a serious cash flow problem for the new sellers. 1.1.2 http://www.ebid.net/ E-bid auction is one of the...
20 Pages(5000 words)Assignment

Database Design Proposal

...Database Design Proposal Database Design Proposal This proposal aims at designing a database for a health organization. The health organization deals with bulky health records of patients and staff every day. Therefore, a database system that keeps proper track of all the activities of the facility is necessary. The proposal seeks to come up with an easy-to-use, fast, secure and reliable system to safeguard health information in the organization (Stubbs & Webre, 2011). It also proposes a system that is cheap to design and easy to maintain. The tool used for the database management will be...
3 Pages(750 words)Article

Principles of Database Design

...Principles of Database Design Principles Of Database Design Disaster Recovery and Business Continuity Plans Business continuity and disaster recovery refer to the contingency plans and measures designed and executed by a business to guarantee operational flexibility in case of any service interruptions. As information technology systems have become the focus of all areas of business, the capacity to reliably and promptly recuperate these systems have become a vital issue in any business. A Business Continuity Plan identifies a business’ vulnerability to both internal and external threats and manufactures soft and hard assets that offer efficient prevention and recovery for the business. At the same time, it retains value system... ...
2 Pages(500 words)Essay

Database Design- Dependency Diagram

... such as in the shared accesses to the main storage, which is not illustrated in a dependency diagram. A CRUD diagram might also be used to illustrate dependency among some of the processes that are not shown in the dependency diagram such as the year –end time dependency among processes. Fig 1.1 dependency diagram Work cited Bagui, Sikha, and Richard Earp. Database design using entity-relationship diagrams. 2nd ed. Boca Raton, FL: CRC Press, 2012. Print.... s Dependency diagram and its use A dependency diagram is a graphical representation of a dependency chart graphs. These diagrams are vital in software pack development by outlining the complexity and the interrelationships of various functional elements (Bagui and Earp 739). However,...
1 Pages(250 words)Essay

Database Design Proposal: Analysis

...Health Care Data Management: Database Design Proposal Analysis and User Needs Identification of database users There will be 3 groups of users of the proposed database: 1. Management of the facility 2. Workers at the health centre 3. Patients who are treated at the health care centre Individual needs of database users Top management: to administer the database including altering its structure and layout Workers at the health care centre: data retrieval related to their respective departments Patients: Read-only access to log in and view their own medical record Specific examples of possible uses by the management: The top management would like to know how many patients there are. The management would like to know which patients... to the...
3 Pages(750 words)Essay

Database Design Conflicts

...Database Design Conflicts Introduction People think database design is a simple topic, but in actual fact it is a very complicated subject. In view of the fact that a correctly planned database arrangement is a design of a company, or a number of "things" in the actual world. Thus, similar to their physical model equivalents, data models facilitate them to obtain responses concerning the information that structure the objects being formed. In addition, queries that require answers decide that which details require being stored competently in the data model. In a relational database data is stored in different tables in...
9 Pages(2250 words)Research Paper
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.

Let us find you another Essay on topic Database design for FREE!

Contact Us