top-rated free essay

IT3400 Chapter 5 Assignment

By hk6498 Nov 09, 2014 455 Words
1. Define each of the following Terms
a) File Organization: A technique for physically arranging the record of a file on secondary storage devices. b) Sequential File Organization: The storage of records in a file in sequences according to primary key value. c) Indexed File Organization: The storage of records either sequentially or consequentially with an index that allows software to locate individual records. d) Hashed File Organization: A storage system in which the address for each record is determined using a hashing algorithm. e) Denormalization: The process of transforming normalized relations into non-normalized physical record specifications. f) Composite Key: Consists of more than one attribute to uniquely identify an entity occurrence. g) Secondary Key: One field or a combination of fields for which more than one record may have the same combination of values; also called a nonunique key. h) Data Type: A detailed coding scheme recognized by system software, such as DBMS, for representing organizational data. i) Join Index: An index on columns from two or more tables than come from the same domain of values. 2. Match the following terms with the appropriate definitions:

Extent: D. A contagious section of disk space
Hashing Algorithm: F. Converts key value into an address
Index: B. A data structure used to determine in a file the location of a record/records
Physical Record: G. Adjacent fields.
Pointer: E. A field not containing business data.
Data Type: A. A detailed coding scheme for representing organizational data.
Physical File: C. A named area of Secondary memory
3. Contrast the Following Terms
a) Horizontal Partitioning; Vertical Partitioning
Both methods of partitioning involve the creation of additional tables. However, Horizontal Partitioning involves the partitioning of tables to reduce the number of rows, where as vertical partitioning results in more tables with fewer columns.

b) Physical File; Tablespace
A tablespace specifies the storage location of a physical file in a database.
c) Normalization; Denormalization
Normalization results in a database that with pieces of information that are broken into individual, separate tables. A normalized database is created specifically to remove redundant data. However, denormalized databases maintain or add redundant data to speed up read time.

d) Range control; Null control
Range control limits the the allowable values in a field (e.g. number values, number of characters, etc). In contrast, Null control prevents leaving a field empty.
e) Secondary Key; Primary Key
A Primary Key is the main reference key for a given table. A Secondary Key is a candidate key that could also serve as a Primary Key.

4. What are the major inputs into physical database design?
Logical database structures developed during logical design
User processing requirements identified during requirements definition Characteristics for the DBMS and other components of the computer operating environment

Cite This Document

Related Documents

  • level 5 Assignment 6

    ...supported living houses have been given copies. Individuals are given support to complete the forms as and when required. 2.5 Review the procedures that have been developed against regulatory requirements, codes of practice and relevant guidance Our procedure includes the stages of procedure and timescales involved. Initially the complaint...

    Read More
  • Juvenile Justice Chapter 5 Assignment

    ...Juvenile Justice Chapter 5 Assignment Cristian Contreras Shaw and McKay’s developed their own theory in the 1920s; this was one of the first attempts to focus on the social conditions that lead to delinquency. They wanted to explain why juvenile crime rates were so high in areas of a city characterized by urban decay. Why was there increa...

    Read More
  • chapter 5

    ... Chapter Five Society lays out all the behaviors, influences, ideas, and attitudes for every individual. If we were born in a different society it would create a totally different person. Our lives, ideas, values, and goals would all be different from the life we are living today. For example, if we were raised in a hunting an...

    Read More
  • Chapter 5

    ...Chapter 6 BIG QUESTION: How did a war fought jointly by the colonists and British help pave the road the American Revolution? Use PERSIA to help in analyzing this question. The war against the French helped bring the colonies closer together. The Albany Congress brought up the idea of uniting the colonies to help them succeed in the future. ...

    Read More
  • Chapter 5

    ...Ch. 5 – Sensory, Attentional and Perceptual Processes 1 Explain the functional limitations of sense organs. Ans. Our sense organs function with certain limitations. E.g. our eyes cannot see things which are very bright or dim. Our senses function within a limited range of stimulation. In order to be noticed by the sensory receptor, a stim...

    Read More
  • Chapter 5

    ...with would be FEMA (Federal Emergency Management Agency). 1. Specialization: They specialize in the response of emergencies by working with local and state governments. 2. Hierarchy of positions: FEMA arranges workers in vertical ranking. You may view this information at 3. Rules and regulations: ...

    Read More
  • Chapter 5

    ...Chapter 5 1. Why is important to help children develop cognitive skills during the preschool year? According to Rike, Izumi-Taylor, and Moberly (2008), it is the richness of a child’s experiences that directly affects the development of the brain. They say: “[R]ecent brain and educational research clearly shows these neural pathwa...

    Read More
  • Chapter 5

    ...Chapter 5: Making a Living I. Adaptive Strategies Yehudi Cohen (1974) argued that similar economic causes have similar sociocultural effects Ex. There are clear similarities among societies that have a foraging strategy Cohen developed a typology of five adaptive strategies: Foraging Horticulture Agriculture Pastoralism Industrialism A. For...

    Read More

Discover the Best Free Essays on StudyMode

Conquer writer's block once and for all.

High Quality Essays

Our library contains thousands of carefully selected free research papers and essays.

Popular Topics

No matter the topic you're researching, chances are we have it covered.