Nobody downloaded yet

Conceptual And Logical Database Design - Assignment Example

Comments (0) Cite this document
Summary
The reporter casts light upon the fact that a database entails a component where data is stored. Data basically are blocks of information. Database systems and design focus on the creation and implementation of a database to suit an information system…
Download full paperFile format: .doc, available for editing
GRAB THE BEST PAPER94.8% of users find it useful
Conceptual And Logical Database Design
Read TextPreview

Extract of sample "Conceptual And Logical Database Design"

Download file to see previous pages Having viewed these key definitions surround database system, we will apply these principles in the modeling of a database system for our information system. We will model a database that will support a student’s electronic voting system. That will be our business scenario for the study.
The Campus student’s council voting system was initialized as a way of electing the student's representatives. Due to the large numbers of the students, the current manual system calls for a sampling of student’s representatives from every faculty to form an Electoral College. This college would then meet and elect the council members. Thus, the students only participated indirectly in the election process. There is no doubt that this process undermines the whole process of democracy within the student population. This is worsened in cases where aspirants influence the vote of the Electoral College.
In an effort to restore credibility within the election process, we will aim at creating a direct involvement of the whole student population in the election of their leaders. In order to handle the large populations, it, therefore, calls for an electronic voting system. This would not only create transparency but also shorten delays in election conduction period right from voting to polling of results. For an efficient electronic system to exist, it calls for an expertly analyzed database system. It will be the core of this system. For the purpose of this study, we will critically apply the fundamental principles involved in database design and modeling.
A conceptual database design captures how data is modeled. This implies the use of entity relational modeling aspect. This approach will mean deciding the entities that will be part of the system. Linking these entities together and coming up with a suitable schema.
The above entities show a one to one relationship with the Voters_Choice entity. This creates the rule that a student can only have one choice and can select the various candidates once. This confirms the integrity of the whole system ...Download file to see next pagesRead More
Cite this document
  • APA
  • MLA
  • CHICAGO
(Conceptual And Logical Database Design Assignment, n.d.)
Conceptual And Logical Database Design Assignment. Retrieved from https://studentshare.org/information-technology/1790981-database-oracle-sql
(Conceptual And Logical Database Design Assignment)
Conceptual And Logical Database Design Assignment. https://studentshare.org/information-technology/1790981-database-oracle-sql.
“Conceptual And Logical Database Design Assignment”, n.d. https://studentshare.org/information-technology/1790981-database-oracle-sql.
  • Cited: 0 times
Comments (0)
Click to create a comment or rate a document

CHECK THESE SAMPLES OF Conceptual And Logical Database Design

Smart Database Design to Avoid Fault Data

...integrity, completeness, accuracy and uniqueness. The methodology for developing a database design has the following three (3) main phases (Elmasri & Navathe, 2004). i. Conceptual database design ii. Logical database design iii. Physical database design As the objective of this document is to provide guidelines on the design of the database to avoid fault data, and the logical database design phase is the most critical phase in which the database...
9 Pages(2250 words)Research Paper

Conceptual Design

...Conceptual design (CD) as a process model of design is intuitively appealing because much of design knowledge comes through the experience of multiple, individual design situations. A major task in the development of computer support for design is the identification of the design knowledge to be included in the support tool. Although designers may have difficulty generalizing their heuristics or styles, they usually have no trouble telling stories about previous design situations. If this kind of reasoning can be captured in a computable model of design, the resulting...
18 Pages(4500 words)Essay

Conceptual Design Specification

..., and residential customers in Ontario. The primary functions of the design are the ability of the device to monitor and control energy consumption in an Ontario household and advise the user about the economical use of energy sources namely electricity and gas. Moreover, this wall-mounted device should also be safe, reliable and easy to use for a variety of users including the disabled and multiple ethnic groups. The design team generated five alternative designs which are the remote, the knob controller, the computer-based user interface, the multi-function energy interface monitor, and the energy monitor. The proposed conceptual design is the knob...
12 Pages(3000 words)Essay

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...
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... in A Guide...
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

MIS assignment - Making Database Design: Conceptual Model plz..help me

...MIS Conceptual Model of Hotel booking System Institute Task Task 2 Hotel booking system Explanation In this conceptual model I have developed the class diagram of the system. This class diagram includes 5 main classes that are given below: Customer Guest Booking Payment Room In this scenario this system is able to handle the online booking and handling of the FDU Enterprise Limited hotels booking and customer dealing process. This system will be an online system that will be able to control and manage the overall booking, payment, and customer profile creation tasks. In case of this system’s conceptual model development I have established some assumptions. One of the main...
2 Pages(500 words)Essay

Database systems analysis & design

...formulated and the output of the design was observed with that of expected. This section presents the sample data used and illustrates the test cases that were applied on the data to verify the logical design and the output of the design. Sample Test Data The four entities and the associative entity from the conceptual data model are converted to five tables in the actual database. The structure of each table with the sample is presented below. Table 2 Student Sample Data Number FName LName Sex DOB Permanent...
12 Pages(3000 words)Assignment

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

Logical Database Design

...in the CUSTOMER must have one or more entries in CUST_ACCESS_LOG. While an entry in CUST_ACCESS_LOG must be from one and only one customer. The ER diagram which incorporates all the above assumption/business rules is shown in the below figure: Fig 1: ER model for NHS Health Space In the above diagram, an entry in HEATLTH_RECORD, HEALTH_TARGET, HEALTH_NOTES, MEDICATION, ALLERGIES, CUST_ACCESS_LOG exist only if a corresponding entry exists in CUSTOMER table. Hence these entities are called weak entities and forms total participation with its relationship with CUSTOMER table. Component 2 Physical Database Design 3. Stored Procedure to create tables and insert data --...
14 Pages(3500 words)Assignment
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 Assignment on topic Conceptual And Logical Database Design for FREE!

Contact Us