StudentShare solutions
Triangle menu

Database - Assignment Example

Not dowloaded yet

Extract of sample
Database

Functional Dependency is a property of the primary key. A good FD determines all attributes in relation. A bad FD refers to an attribute that is the key to other attributes in relation. Such sets of attributes are called sub keys of the relation (Jewett, 2006).
Normalization is following a set of rules to ensure that the database has the right design. Normalization rules eliminate unnecessary data in a database. Redundant data results from sub keys and should, therefore, be eliminated. The process of normalization is done in three steps. In the first normal form, repeated and multi-valued attributes are eliminated. The second step involves the removal of sub keys. In the third step, sub keys without primary keys are eliminated (Jewett, 2006).
Contact databases and Phone books exhibit the repeated attribute. They store phone numbers and addresses. Care is taken to prevent leaving fields blank or NULL. In the discussed example, there is one repeated attributed that is the phone. It shows whether the phone number is for work, cell or home. Multi-valued attributes hold additional data for non-formal use such as hobbies. The term hobbies in plural, and entering different hobbies in the same column creates the problem. It creates problems when one wants to query the hobbies in the table or a particular hobby of a person (Jewett, ...Show more

Summary

The values identify the rows of a table. It is a relation property in the table, but not of a scheme. Candidate key refers to a minimal superkey. When a single attribute is removed from a set of data, the super key becomes…
Author : aric32
Database essay example
Read Text Preview
Save Your Time for More Important Things
Let us write or edit the assignment on your topic
"Database"
with a personal 20% discount.
Grab the best paper

Related Essays

Database Systems
In these distributed databases systems, requests and transactions can further categorised as remote and distributed. Requests can be categorise as remote requests and distributed requests. A remote request accesses data located in a single remote data processor site and queries can accesses that locations data only.
1 pages (250 words) Assignment
Database Configurations
The basic purpose for any database in an organization is to serve the purpose of storing transactions and being able to produce reports effectively (Rob & Coronel, 2002). Although, most database analysts would agree with this simplistic definition of a database, there is more to uses of a database than what meets the eye in this definition.
1 pages (250 words) Assignment
Relational Database Assignment
The four prime factors that control the integrity of a database include relationship-level integrity, attribute-level integrity, business rules, and entity-level integrity (Lathem, 2008). Using these relationships, one can divide the data in separate tables.
3 pages (750 words) Assignment
Database
The second layer is the schema of a given database. The third layer is the database itself representing a state of the application's data often called micro-data. The fourth layer consists of the macro-data that are generated from the micro-data by application of view queries to the micro-data (DIETRICH, 2011).
6 pages (1500 words) Assignment
Database assignment
The concerned techniques used for data modeling and the accompanying tools allows for input, translation and conversion of various system designs (both complex and simple) into processes and data flow representations which are easily read and understood .
10 pages (2500 words) Assignment
Database Management System Assignment
A randomly generated test script is utilized to provide variation among test cases and consistency between different runs of the benchmark. The benchmark is platform independent and can be extended to support any database vendor providing a Java data source for connectivity.
19 pages (4750 words) Assignment
Relational Database Design
The Relational Database specification required nine table in the following relationships. A table Textbook with a many-to-many relationship through a junction table (outside join) to the table Module through the Module_Detail table. A many-to-many relationship is required between Module and Field through a join table (outer join or junction table) Field_Detail.
6 pages (1500 words) Assignment
Database
Each asset is regularly inspected, and the date of the inspection, the person who carried out the inspection and details of any maintenance actions are noted. If the asset is a photocopier then the toner is replaced and the total number of copies made is recorded as well as the toner serial number.
4 pages (1000 words) Assignment
Database Management
The growth rate of the following town has seen the apartments booked and the contract is agreed upon with the tenant. The apartments are well furnished with the best quality products and latest fittings
6 pages (1500 words) Assignment
Oracle Database 11g
The database constitutes both logical and physical structures. Since the logical and physical structures are separate, the data physical storage can be managed without necessarily affecting logical storage structure access. Every database instance is
16 pages (4000 words) Assignment
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