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

Teaching Concept of Organizing Data In A Relational Database / Microsoft Access - Essay Example

Cite this document
Summary
Teaching Concept of Organizing Data in A relationship Data Base Name: Tutor: Introduction Microsoft access is a data base management system used to create relational databases made up of tables, queries, forms and reports. Database is an organized set of information or data related to specific attributes, includes tools for working with that data such as summarizing sorting and extracting, table; is a list of related information in columns also referred to as fields and rows referred to as a record (Snell ,2010)…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER96.5% of users find it useful
Teaching Concept of Organizing Data In A Relational Database / Microsoft Access
Read Text Preview

Extract of sample "Teaching Concept of Organizing Data In A Relational Database / Microsoft Access"

Download file to see previous pages

A suppliers table would include fields such as supplier Name, Supplier Number and Address. The field that contains a unique data value to identify each record in a table is referred to as the primary key. Where the suppliers’ names are similar a special identifier is assigned to eliminate confusion when identifying a particular supplier. Till now the SUPPLIER table does not give information about the parts that different suppliers provide. There is need to create a part table being a separate entity from the supplier, creating fields with information relating to parts in the PART table.

Keeping information on parts in the same table as suppliers would result to redundancy on data relating to suppliers making it difficult to retrieve information on particular parts supplier by particular suppliers. The PART table fields include Part Number, Part Name and Unit Price. Include a forth field for Supplier Number to identify the supplier for each part. In both the SUPPLIER and PART tables the Supplier Number is common. In the PART table the Supplier_ Number is the foreign key a look up field identifying data relating to supplier of a specific part and Part_ Number being the primary key.

When organizing data into tables; ensure all the attributes of an entity apply only to that entity (Snell, 2010). Defining data attributes Specific characteristics of entities are referred to as attributes. When operating a business one should consider the specific sets of data involved such as information on suppliers, employees, customers’ orders, products and parts. These data categories are referred to as entities. The next step is to define attributes. For example in the supplier entity attributes include Supplier Name, Supplier Number and address.

The Part entity attributes include Part Name, Unit Price and the supplier of that part (Snell, 2010). Defining relationships between tables Understanding the relationships between different entity tables is important. A representation referred to as entity relational diagram is used to simplify how tables relate in a relational database (Snell, 2010). The three main types of table relationships include one-to-one, one- to- many and many- to- many relationships. One-to-one exists when the primary record has only one related record for instance in a human resource department keeping private information of an employee such as employee name, date of birth, in one table and salary and pension benefits in another table .

With regards to the employee the data stored relates specifically to him or her exhibiting a one-to -one relationship. One-to-many is when primary records have many related records in the related table. For example one supplier can supply more than one part but each part has a specific supplier (Larson, 2009). When we introduce an ORDER table since one supplier provides many orders, one order can be for various parts from a supplier and a series of different orders for a single part this exhibits a many- to many relationship between the PART and ORDER tables.

It’s necessary to create a join table to link the two tables. Minimizing awkward many- to- many relationships and data redundancy through normalization process increases permanence and elasticity of the data (Snell, 2010).

...Download file to see next pages Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Teaching Concept of Organizing Data In A Relational Database / Essay”, n.d.)
Teaching Concept of Organizing Data In A Relational Database / Essay. Retrieved from https://studentshare.org/information-technology/1498006-teaching-concept-of-organizing-data-in-a
(Teaching Concept of Organizing Data In A Relational Database / Essay)
Teaching Concept of Organizing Data In A Relational Database / Essay. https://studentshare.org/information-technology/1498006-teaching-concept-of-organizing-data-in-a.
“Teaching Concept of Organizing Data In A Relational Database / Essay”, n.d. https://studentshare.org/information-technology/1498006-teaching-concept-of-organizing-data-in-a.
  • Cited: 0 times

CHECK THESE SAMPLES OF Teaching Concept of Organizing Data In A Relational Database / Microsoft Access

Cloud Computing Solutions: Deployment Models

Using cloud services, users do not need to buy software applications and install them in their computer systems because they can access those applications using cloud services.... This assignment "Cloud Computing Solutions: Deployment Models" discusses cloud computing that offers a number of benefits to users some of which include increased data storage, workload shift, reduced need for installing costly software applications, user-friendly interface, and resource sharing....
20 Pages (5000 words) Assignment

Data Warehouses with Big Data

RDBMS can thus help an administrator to organize data in an intelligent and retrievable way.... nbsp; Basically, data warehousing is a relatively more intelligent and refined database administration system which can handle large amount of data.... According to Ricardo (2011), traditional form of database administration is based on the fundamental technique of identifying and manipulating the different characteristic entities in a given dataset....
5 Pages (1250 words) Term Paper

Database Management System

Database management system is defined as a system so software that organizes and maintains the data in a database for providing the information.... The database management system conflated the managerial concept of the database with the specific technology of the file management system.... Because all access to stored data is mediated through the DBMS, a database can be restructured or moved to a different computer without disrupting the programs written to use it....
9 Pages (2250 words) Essay

To what extent is there a 'global' communications industry

These systems target the global sector bringing in a greater number of customers from centralized communication and data facilities irrespective of the location of the customers served or national boundaries.... He has stated that the innovative ways of producing, organizing and spreading information has a radical impact on industrial, political and cultural processes and practices....
11 Pages (2750 words) Essay

Information systems 2

Privacy about personal information is of much concern like on financial status for example Tesco supermarkets can access accounts of its credit card holders.... There are loads of concerns about personal data privacy.... Health data should be held secret.... data can be retrieved from different sources.... For Tesco, internal sources of data include sales from internal operations such as sales data, in cventory data, human resource data, systems data, product data and marketing data....
4 Pages (1000 words) Coursework

Importance of Database in Business Administration

The most common types of databases which organizations use are Oracle, microsoft access, SQL, Paradox and DB2.... Organizational databases are developed and maintained in a manner such that all related parties of the business can access it at any given time.... Such databases require high performance servers and speedy network access.... To coordinate and manage all business activities suitably, it is essential for organizations to develop suitable database systems which record all business related information in a… Such information is later on utilized by managers to take important business decisions and to control business activities....
15 Pages (3750 words) Essay

Information Communication Technology Learning with Virtual Worlds

When using the FirstClass system, there is a need to have access to the internet every time and in some instances where there is limited connectivity, it may be difficult to access the services of this software  Learning can be defined as the process of acquiring new knowledge (Ellof & Ebersohn 2004).... The author gives a detailed information about the different software applications used for education which include the following: microsoft Office particularly Excel and PowerPoint, MSN messenger, logo, Mind genius, First class, hot potatoes, and the Scratch programming … The software has got its own benefits as well as drawbacks though it is generally a good tool for distance learning....
23 Pages (5750 words) Essay

Comparing between Database Systems

It is created for a specific purpose of querying data contained in a relational database to solve much wider set of problems (Wikipedia, RDBMS).... he most common way, widely use, most effective, and popular among database developers in organizing data in a database is through data relationship.... Since the report involve technical and procedural knowledge of data handling and manipulation, it is best to start presenting the issue by dealing with the nature of databases, the relational database Management System, SQL, and Multimedia files....
10 Pages (2500 words) Essay
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