StudentShare solutions
Triangle menu

Database Design - Essay Example

Not dowloaded yet

Extract of sample
Database Design

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

Entities:
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 ...Show more

Summary

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.
Author : aboyer
Database Design essay example
Read Text Preview
Save Your Time for More Important Things
Let us write or edit the essay on your topic
"Database Design"
with a personal 20% discount.
Grab the best paper

Related Essays

Database Design Process Project (Preparation)
As the development of a database and automation of the Riordan Manufacturing Virtual Organization is under process, therefore, it is required for the organization to know the uses of the MS Visio. The Microsoft Visio provides a What You See Is What You Get (WYSIWYG) environment for the development of entity relationship diagrams.
3 pages (750 words) Essay
Database Design & Development
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
4 pages (1000 words) Essay
Database Design Project
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
8 pages (2000 words) Essay
Principles of Database Design
A Business Continuity Plan identifies a business’ vulnerability to both internal and external threats and manufactures soft and hard assets that offer efficient prevention
2 pages (500 words) Essay
Database Design- Dependency Diagram
These dependency diagrams are used to assist in the normalization of data in a given database. They are used to show the high level of dependence between modules in a database structure. It might
1 pages (250 words) Essay
Database Design Proposal: Analysis
However, a number of possible redundancy and coherency issues and other challenges should be acknowledged and dealt with, which are detailed below. In addition, an issue of data coherency could arise if care is not taken to different data pertaining to the same entity
3 pages (750 words) Essay
Database Design and data security breeches
This is because avoid the issue where information released to a person are used for other purposes that can be detrimental to both the patient and the healthcare institution. The IRB waiver can be applied if the information is
2 pages (500 words) Essay
Database design and SQL Light database creation
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
3 pages (750 words) Essay
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
2 pages (500 words) Essay
Database Design
The unique movienumber serves as the primary key. All the movies fall under DVDs, VBS or VCD. Customers pay fines for spoilt and late return of rented videos. The customers orders for videos. They can
1 pages (250 words) Essay
Get a custom paper written
by a pro under your requirements!
Win a special DISCOUNT!
Put in your e-mail and click the button with your lucky finger
Your email
YOUR PRIZE:
Apply my DISCOUNT
Comments (0)
Rate this paper:
Thank you! Your comment has been sent and will be posted after moderation