Database and Spreadsheet Essay

Submitted By samirbhoir
Words: 1717
Pages: 7
Open Document
College of Technology London | DATABASE AND SPREADSHEET | Module Code: SBIT5003, Assignment 1 | Date: 15th April, 2011 – Word Count : 1496Term 3 | SAMIR BHOIR |
STUDENT ID: 105065-83
UWL ID: 29002700/1
E-Mail: 105065-83@stu.ctlondon.ac.uk

Submitted to:
Dr. Jin Wu |

Table of Content 1.0 Introduction: 3
2.0 Database Elements 3 2.1 Queries 3 2.2 Reports 4 2.3 Attributes 4
3.0 Standard Approaches of DB Design: 4 3.1 Entity – Relationship Diagram: 4 1) Entity 4 2) Primary Key 4 3) Relational Database 5
4.0 Table Structures 7 4.1 Patient Table 7 4.2 Booking 8 4.3 Therapist 8 4.4 Therapy Type 10
5.0 Conclusion 11
6.0 References 12

1.0 Introduction:
This Report is totally based on Database system and is explaining about creation of database with help of Therapy Clinic database, in which element of database such as Query, forms, attributed and reports are very well explained. Also different approaches of database are been discussed such as E-R diagram, Here the Relationship structure is been demonstrated with the help of Entity Relationship Diagram.
Database basically means the collection of data which is properly managed and stored such that it can be retrieved very fast as said by Author Parsons and Oja. Database can be in structured and free form, Phone book in our mobiles phones is an example of structured database whereas any document stored on our personal computer is called as free form of database, or even a CD which normally comes with any magazine or newspaper is a free form of database, the documents we find on internet are also termed as free from of database. The Structured database will always have files, records, fields which are appropriately organized. In structured database record contains entity which has field such as person, place, thing or any event (Parsons and Oja, 2008)
However Author Ramez Elmasri and Sham Navathe says that Database is the collection of recorded facts, and the typical database will always represent real aspect of world, Database and data base software together forms a database system. Here they classified data in to structured and unstructured data.
Database management system generally consists of Access, SQL server, and MySQL the practical example of Database management system is the CTL student information systems and the account management systems in CTL.
2.0 Database Elements Database Design generally follow the Hierarchy such as Database server, Database application system, Tables, Queries, Forms, Reports and Modules, here tables consists of fields and records. Database Design is the process of creating design for a database that will maintain the enterprises operations and objectives and gather the enterprises information needs.
2.1 Queries
In Database system the mechanism used to retrieve the required information from the stored data is called as Queries in Database system. Queries are generally in question form which is presented to database in proper format to get right information. Usually Structured Query Language (SQL) is used for standard query format.
2.2 Reports
In order to print the information required in the database is produced using Reports, which are generally designed automatically using database tools. Reports are generally required if hard copy of particular information from database is required (Database Report, 2011).

2.3 Attributes
Attributes in the database represent the characteristics or value with respect to the database relation. They are explicit values such as quality or any particular characteristic. Attributes in database are referred to fields and columns in the table. It is used to identify the entity. Attributes are generally of two types Composite attributes and Derived attributes. Attributes that can be composed of other attributes is called Composite attributes, whereas the
Show More

Related Documents: Database and Spreadsheet Essay

Productivity Software In The Classroom

Educators may know how to use technology for their own productivity, but may not understand the best ways to use it to increase student learning and to engage student interest. In lesson two types of productivity software are explored, and spreadsheets and databases are specifically discussed in your textbook. How to most effectively use these two types of software in the classroom is explored. Because Microsoft Office Excel and Access are the most commonly used pieces of software in this field…

Words 1740 - Pages 7

Nt1330 Unit 3 Data Analysis

between a Spreadsheet and Database Difference Spreadsheet Database 1 Used to tabulate data and create graphs Used to store data so it can be retrieved by users 2 Cannot hold too much tabulated data Can hold large amounts of data at any time 3 Can be edited by users directly and manually Automatically updated by users indirectly via applications that enter data 4 Usually used in cases of presentations Commonly used in cases where a lot of data needs to be stored In prospective: A spreadsheet can…

Words 500 - Pages 2

Database: Database and Microsoft Excel Essay

Database Database A database system is defined as a integrated computer structure which stores collections of end user or meta data. In any organization, a database system is very important. Databases can be used to store any information you to collect and store. This information could be a company storing information on all of its employees or a company collecting monthly sales data. The size of the organization or company will determine how you will store this data. Microsoft Access is a great…

Words 412 - Pages 2

Nt1310 Unit 3 Unit3

the PC was the spreadsheet (VisiCalc) 5. Enterprise resource planning (ERP) is process management…

Words 1189 - Pages 5

Computer crime involves Essay example

Computer crime involves:  Theft by computer (including identity theft and phis hing)  Software piracy and intellectual property misuse  Software sabotage (malw are- including worms, viruses, Trojan horses, e tc.)  Hacking and electronic trespassing. The computer crime dossier  Computer crime: any crime accomplished through knowledge or use of computer technology  Businesses and government institutions lose billions of dollars every year to computer criminals  The majority of crimes is committed…

Words 7422 - Pages 30

Efficiency & Collaboration Proposal Essay

responsibility of this team to achieve this important goal. This company has been using Microsoft® Excel®, which is a very successful program here in the Sales Department. In order to improve efficiency, data must be migrated into a relational database, streamline the departments work processes, and improve communications within the company. Below is the team assessment and proposal. The system of information coordinates activities and provides a vehicle of communication throughout the organization…

Words 682 - Pages 3

Following and Sub Procedure Essay

following: Sub querydata() src = "SELECT * FROM Manufacturers" Dim cntMyConnection As ADODB.Connection Set cntMyConnection = New ADODB.Connection CnctSource = "DRIVER={MySQL ODBC 5.1 Driver};Server=localhost;Database=YOURDB; Uid=root; pwd=YOURPASSWD; OPTION=3;" cntMyConnection.Open ConnectionString:=CnctSource Dim rstFirstRecordset As ADODB.Recordset Set rstFirstRecordset = New ADODB.Recordset rstFirstRecordset.Open Source:=src…

Words 577 - Pages 3

Nt1330 Unit 3 Data Testing Paper

whole process so we would have a while constructed database.…

Words 593 - Pages 3

Nt1330 Unit 1 Assignment

1. Question: Why are databases the basis of businesses today? Your Statement: Databases are the core of businesses. They can store and organize customer and client information as well as keep track of product inventory. Proofs: 1. Date bases are widely used for storage of information. Not only do they store data, but also information used to manage the data. 2. Databases provide data continuity at all reference points. 3. With data bases you can grant and manage access rights. You can allow…

Words 929 - Pages 4

System Media Assignment

Hierarchical database; this is a ranked database, which purpose is to organize data to form a treelike structure, in a pyramid opposite. All access to the data starts from the hierarchy and moves downward. The hierarchy of parent and child data segment is an example. IMS is the most popularly used. It is developed by IBM and windows Registry by Microsoft. The Hierarchical database collects all instances of a specific record together as a record type. It also allows repeating information. Flat database; this…

Words 1941 - Pages 8