Database Design - Essay Example

Only on StudentShare

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 consideratio ...
Download paper

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

Related Essays

Structured Systems Analysis and Design Method
(1)
...
6 pages (1506 words) Essay
Object Database Management System
There are two most important factors that lead users to implement object database technology. Firstly, relational databases turn out to be cumbersome to use with composite data. Secondly, data is usually operated by application software written using object-oriented programming languages such as C+, Java, Delphi and C#, and the code required translating between this demonstration of the data and the tuples of a relational database can be dreary to write, and prolonged to execute. This variance between the models used to represent information in the application programs and the database is...
8 pages (2008 words) Essay
Database Technology
Object oriented databases have now become very popular as they provide a greater degree of flexibility in data storage and also provide a resource efficient storage mechanism. The data storage in the object oriented databases is in the form of objects instead of storing as rows and columns.
...
13 pages (3263 words) Essay
Object Relational Database
In ORDB, reusability is achieved by using the techniques of inheritance of types and polymorphism. Every record has unique identity within the object table. Here every record is termed to be active, persistent objects encapsulating both data and methods. The only way to access any data, is through the object methods.
...
12 pages (3012 words) Essay
Relational Database Design
A many-to-one relationship must be made between the Session table ( a group of the Lecture table and the Practical table) and the Module table. The Lecture table and the Practical table are both join tables which allow the necessary one to many relationship with the Tutor table and the Session table and the many-to-many relationship between Tutor and Session table. A one-to-many relationship should be constructed between the Tutor table and the Lecture table. Finally, a many-to-many relationship between the table Tutor and the table Practical must be created. The versions of MySQL used for...
6 pages (1506 words) Assignment
Database
Inspectors have a unique inspector number, and the details of their name and position are held on record. Products are identified by their name and records of the product type and a description of the product are kept.
...
4 pages (1004 words) Assignment
Got a tricky question? Receive an answer from students like you! Try us!