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

RELATIONAL DATA MODEL - Essay Example

Cite this document
Summary
Oracle database is one of the relational database management systems that is used for creation and maintenance of the database components such as tables. A relational database is made of a table that forms the basic unit for storage of data in the database. The database offers…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER96.8% of users find it useful
RELATIONAL DATA MODEL
Read Text Preview

Extract of sample "RELATIONAL DATA MODEL"

Relational Data Model Number Lecturer Relational Data Model. Oracle database is one of the relational database management systems that is used for creation and maintenance of the database components such as tables. A relational database is made of a table that forms the basic unit for storage of data in the database. The database offers commands and functions that are used in the manipulation of the data and records that are stored in the database. The most basic step towards using the oracle database management system is to install the system in the computer and be able to run it and use it to carry out relational database management activities.

I use a Windows 7 operating system; therefore I used the Oracle developer client Program to connect to connect to the database. However, I experienced some challenges while using the command prompt to type the required commands. Additionally, I was not sure at which step am I supposed to create my user name and password that will allow me to connect to the database. After a few trials the connection was set and I was able to test the connection successfully. According to the connection steps and instructions this allowed me to connect to the database as a developer.

Hence, I was logged in to the Sql developer environment. Here are some of the specific experiences I had with the various commands that are used in the Oracle database;Viewing HR schema objects.This is viewed from the connections frame, which is found to the left of the hr_conn.This process is quite simple; by clicking the + sign, all the HR schema objects are displayed such as tables, views, indexes are displayed. Viewing Data and properties of a table.Viewing data and properties of any table involves selection of the table and selecting data to be able to view the records that are stored in the table.

The properties such as constraints can also be viewed by selecting the constraints tab in the connections frame. Other properties can be viewed by selecting the appropriate tabs in the connections frame.Selecting data from a table.Selection of data from a table in Oracle database is achieved by using queries. The SELECT statement is used to select data and records from a table or views. By using additional commands, selection can be narrowed down to specific criteria. The SELECT statement is simple to use but requires mastery of the syntax to be used , it has both the select list such as columns from a particular table and a source list that specifies the table from which the records and data are to be sourced.

SELECT statement helped me to select all the columns from the Employee table. Selection of specific columns required mentioning the column names in the SELECT statement command. These data could also be narrowed down to specific items matching specific criteria. The process is simple but requires mastery of the syntax to be included in the SELECT statement. Data can be selected from several tables from the same database. The data can then be used for reporting purposes. The system allows sorting and arrangement of the data based on different criteria.

The system also allows the use of arithmetic operators and numeric functions in manipulating data records retrieved from the tables. References.Oracle.com. (2014). Connecting to Oracle Database Express Edition and Exploring It. Retrieved 11 09, 2014, from Oralce.com: http://docs.oracle.com/cd/E17781_01/appdev.112/e18147/tdddg_connecting.htm#TDDDG99998

Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“RELATIONAL DATA MODEL Essay Example | Topics and Well Written Essays - 500 words”, n.d.)
RELATIONAL DATA MODEL Essay Example | Topics and Well Written Essays - 500 words. Retrieved from https://studentshare.org/information-technology/1664559-relational-data-model
(RELATIONAL DATA MODEL Essay Example | Topics and Well Written Essays - 500 Words)
RELATIONAL DATA MODEL Essay Example | Topics and Well Written Essays - 500 Words. https://studentshare.org/information-technology/1664559-relational-data-model.
“RELATIONAL DATA MODEL Essay Example | Topics and Well Written Essays - 500 Words”, n.d. https://studentshare.org/information-technology/1664559-relational-data-model.
  • Cited: 0 times

CHECK THESE SAMPLES OF RELATIONAL DATA MODEL

Features Of The Speedy Wheels' Business Strategy

As Helpin & Tony (2010) have stressed that “the information model that clearly reveals the underlying semantics of the domain” is considered the best model, therefore, the proposed information model will be based upon a RELATIONAL DATA MODEL and various entities within the model will have a closer relationship with each other.... The model consists of the following major entities (Tables).... nbsp;Following is a list of three major relations that exist between various entities of the model;...
3 Pages (750 words) Essay

Information Systems (IS) Application: Part-Time Instructors and the Short Courses Database

This paper will discuss the application of information systems to an educational institution that offers short courses taught by part-time instructors, supported by data modeling using the data flow diagram (DFD) and entity-relationship diagram (ERD).... This paper will discuss the application of information systems to an educational institution that offers short courses taught by part-time instructors, supported by data modeling using the data flow diagram (DFD) and entity-relationship diagram (ERD)....
10 Pages (2500 words) Essay

Bela Pinga Ltd Company

After that, E-R Model and RELATIONAL DATA MODEL (RDM) will be analyzed for sale office system.... igure 1 shows the E-R model for the Sale Order Processing View of Bela Pinga Ltd.... This report will analyze the sales processing of the Bela Pinga Ltd, which is located in Commercial Street, Sheffield, receives and processes sales orders....
6 Pages (1500 words) Essay

Bounds of Relational Technology in the United States

Relational Technology solutions offer an exceptional procedure to get rid of a legacy database system, it interfaces intimately with system customers to reconfigure the legacy data and information model into an existing relational database design.... hellip; Today, Relational Technology presents the networking or the VoIP Network inclination evaluations for design, security solutions, data, evaluation, wireless solutions, performance, and arrangement services with specialized functions and systems....
2 Pages (500 words) Essay

Sports Club Entity Model

The RELATIONAL DATA MODEL is based on relational data structures, integrity constraints and smooth access to Data Definition Language and Data Manipulation Language statement for creation and retrieval of data.... The flavors of the databases used for… This report “Sports Club Entity model” contains a complete description of the Sports Club entity model.... Choosing a database model is of greater importance....
8 Pages (2000 words) Essay

Components of Databases

The RELATIONAL DATA MODEL, Normalisation and effective Database Design.... An entity is in the first normal form if it contains no repeating sets of data.... This wastes a lot of space in the data base.... To normalize the ERD into INF we eliminate the redundant data....
1 Pages (250 words) Assignment

The History and Contributions of Database Management Systems

It was IBM that supported the further development of DBMS by introducing in the 1970s a different scheme of data representation; the new scheme was called 'RELATIONAL DATA MODEL' (Ramakrishnan et al.... At a next level, the further development of DBMS was achieved through the creation of a supportive scheme  - referring to the support provided to the IMS – that could be used as an alternative framework for data representation; this scheme is known as 'hierarchical data model' (Ramakrishnan et al....
6 Pages (1500 words) Research Paper

The Use of Temporal Database in the Data Management System

The RELATIONAL DATA MODEL has become popular in the last 20 years due to its simplicity and the tried and test mathematical foundation it possesses.... One such model includes that of a temporal database, along with relational database, object-oriented database.... This particular paper addresses the use of the temporal database in the data Management System (DBMS).... A temporal database is a means of holding temporal data of a temporal version of a Structured Query Language....
5 Pages (1250 words) Article
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