Database Design - Essay Example

Comments (0) Cite this document
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 the envisaged business application at a strategic level.
Download full paperFile format: .doc, available for editing
GRAB THE BEST PAPER95.7% of users find it useful
Database Design
Read TextPreview

Extract of sample "Database Design"

Download file to see previous pages Furthermore, the information model comprises of the customer and the details of the meter including the intricate technical details as well as the maintenance schedules apart from the measurements that quantify for billing. This is necessary for the effective management of the information system and conduct regular checks on the meters in order to prevent errors in the readings leading to unwanted reconciliations for the organization.
The conceptual design of the database model also includes the use of the billing efficiently both during the period of operation for the meter as well as at the time of removal and installation of the new meter. This method although straight forward in words is actually a complex procedure as it not only involves the company and the customer but also the supplier for the meter that is installed at the customer site. The need for policy compliance and related issues make the process complex and the information model should address this.
The conceptual design being the high level specification of the information model to be deployed without any system restrictions into account or technical considerations, the conceptual design also comprises of the following at a strategic level implementation
1. The billing section to be notified of any new changes in the metering for a given customer once the change is completed.
2. The information system should account for the price of the gas that is dynamic on a day-to-day basis. The gas price being fixed using a dynamic bidding process in the UK energy market should be accounted for whilst calculating the bills and any reconciliation to the customers.
3. The information model should also include the dynamic transportation charges for the gas from the source to the customer, which is additional to the gas pricing on a day-to-day basis for the quantity of gas being transported every day.
Logical Design:
The logical design is implemented using the Entity Relationship diagrams as follows
The entities identified in the logical design of the application include
1. Customer
2. Validation
3. Meter
4. Supplier
5. Billing and Reconciliation
Among the aforementioned the first four are the primary entities in the database with the Billing and Reconciliation forming the transaction in the system. This makes it clear that any trigger implemented with regards to the finance processing will reflect upon the transactions on billing and reconciliation entity only. The relationships between the entities identified are discussed below followed by the entity relationship diagram adhering to the UML standards.
The customer being the first and important element of the system identified is placed central to establish the relationship with other entities based upon the customer.
Customer - Meter: the relationship between the customer and the meter is deemed to be 1N. This ...Download file to see next pagesRead More
Cite this document
  • APA
  • MLA
(“Database Design Essay Example | Topics and Well Written Essays - 3500 words”, n.d.)
Database Design Essay Example | Topics and Well Written Essays - 3500 words. Retrieved from
(Database Design Essay Example | Topics and Well Written Essays - 3500 Words)
Database Design Essay Example | Topics and Well Written Essays - 3500 Words.
“Database Design Essay Example | Topics and Well Written Essays - 3500 Words”, n.d.
  • Cited: 0 times
Comments (0)
Click to create a comment or rate a document


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 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 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

...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... to...
2 Pages(500 words)Essay

Consumer Research on Ethical Consumption

13 Pages(3250 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