StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...
Free

IT163 BD Unit 2 - Research Paper Example

Cite this document
Summary
The first step in designing a database is to simply brainstorm on paper concerning what the database will need to store and what the site will need out of it. The individual fields, tables and other branches are not considered at this point because the specific planning can take…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER94.6% of users find it useful
IT163 BD Unit 2
Read Text Preview

Extract of sample "IT163 BD Unit 2"

FUNDAMENTAL ASPECTS OF DATABASE DESIGN AND PLANNING [School] Number] September 8, Fundamental Aspects of Database Design and Planning The first step in designing a database is to simply brainstorm on paper concerning what the database will need to store and what the site will need out of it. The individual fields, tables and other branches are not considered at this point because the specific planning can take place later. The aim is to start with general and the complete view will follow. It can often be difficult to add items later, rather than get them right away on the first time.

The first and most important step for the successful operation of a distributed relational database is through proper planning. The objectives and needs of the enterprise must be considered when making decision on what to use in a distributed relational database. How the application program is going to be coded, where it resides in regard to the data and the network design that merges or connects the application program are all very important design considerations. Database design in a distributed relational database is more complex than when dealing with the I series relational database.

It is important to understand the purpose of the business or the organization for which the database is to belong and the relational database technology. Operations that necessitate particular attentions when forming your strategy include general operations, networking protocols, system security, accounting, problem analysis and backup and recovery processes involved. Of great importance is to avoid replica of rows of the same data available in a database. This is referred to as data redundancy.

Data redundancy gives problems to IT departments responsible for database management. Redundancy can be avoided by the use of keys in tables. For example, in the database of an organization for accessing and storing employees’ data, then for each employee we have a defined primary key condition for employee number. If an attempt is made to enter a second row of the same data for the employee the system should rejects. ReferencesTaylor, B. M. (2011). Database Management. A Fundamental Approach to Database Design.

Retrieved from http://it.toolbox.com/blogs/programming-life/a-fundamental-approach-to-database-design-7827

Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“IT163 BD Unit 2 Research Paper Example | Topics and Well Written Essays - 250 words”, n.d.)
IT163 BD Unit 2 Research Paper Example | Topics and Well Written Essays - 250 words. Retrieved from https://studentshare.org/design-technology/1617686-it163-bd-unit-2
(IT163 BD Unit 2 Research Paper Example | Topics and Well Written Essays - 250 Words)
IT163 BD Unit 2 Research Paper Example | Topics and Well Written Essays - 250 Words. https://studentshare.org/design-technology/1617686-it163-bd-unit-2.
“IT163 BD Unit 2 Research Paper Example | Topics and Well Written Essays - 250 Words”, n.d. https://studentshare.org/design-technology/1617686-it163-bd-unit-2.
  • Cited: 0 times

CHECK THESE SAMPLES OF IT163 BD Unit 2

Analysis of Dietary and Nutritional Status

The paper is aimed to examine and analyze one's own diet to be able identify possible excesses or deficiencies in the health on the basis of the standard dietary and nutritional requirement.... The analysis of a person's diet for a particular period of time can be considered… For that matter, when such data is analyzed certain nutritional imbalances can be determined or predicted....
6 Pages (1500 words) Essay

IT117 Unit 2 DB

An eye catching design of a website is one core factor to be taken into consideration.... It is of great importance to include all the information that the… In the development of the Karina's site, the following additional features could sell out the website to a large extent: Social media integration – the website should be well integrated with social medias such as Facebook and Twitter in Website Plan [School] Number] September 8, Website Plan Building a website requires that one should grasp certain little secrets and tiny ways in order to achieve the best results....
1 Pages (250 words) Research Paper

IT163 Unit 5 BD

This is an example of a data manipulation statement.... This is in the sense that the data that is stored in the database is manipulated to get the required information.... A join query is a SQL statement that is used for the retrieval of… There are two differences between join query and normal query....
1 Pages (250 words) Research Paper

IT163 unit 6 bd

One of the main purposes of designing a good web form for taking input or information from the users is the usability and collecting accurate information.... If the web forms are not properly designed the users would irritate and hesitate to provide information, as they need to put… Moreover, the forms text / questions to be answered by the users should be precise in a way that the users can perceive the questions unambiguously and able to provide accurate information....
1 Pages (250 words) Research Paper

Proteomic Profiling and Data

"Proteomic Profiling and Data" paper focuses on proteomics, a field in life science research that is used to characterize all the proteins in a cell.... It makes use of high throughput technologies like 2D-GE and mass spectrometry to come up with what is known as a peptide mass fingerprint.... nbsp;… The results of the Mascot search using different parameters and the two databases came out with the same ID each time....
9 Pages (2250 words) Assignment

The Theory of Planned Behavior

In the essay “The Theory of Planned Behavior” the author analyzes norms and behavior, which have a basis on a set of beliefs.... Human behavior is guided by several considerations.... One of the considerations is the human belief on what the likely outcomes might be and how they may influence the decisions....
8 Pages (2000 words) Assignment

Land and Soil Capability

… The paper "Land Evaluation: Developing A Land Capability Scheme And Rating Table For Blackville Area" is a great example of a case study on agriculture.... nbsp; There is a need to put into consideration on-site and off-site impacts in the process of assessment of land and soil capability (LSC)....
6 Pages (1500 words) Case Study

Computational Fluid Dynamics

Mathematically, these governing equations are expressed in the form: Equations of conservation Conservation of Mass Conservation of Energy: Conservation of momentum: Where: – Density of fluid – Velocity of fluid – Temperature – Fire –induced pressure – Denotes the unresolved viscous stress tensors and momentum flux lumped together – Fluid vorticity – The vertical component of the velocity – Specific heat – Denotes radiant energy flux and conduction heat flux – Chemical heat released per unit volume – Ambient pressure – Height – Gravitational force Another important equation is the equation of state....
12 Pages (3000 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.
Contact Us