The Creation of a Relational Database Using Microsoft Access

The Creation of a Relational Database Using Microsoft Access

Length: 495 words (1.4 double-spaced pages)

Rating: Excellent

Open Document

Essay Preview

More ↓
The Creation of a Relational Database Using Microsoft Access

I will be using Microsoft access to create a relational data base.
This will let me to make tables that contain data on a specific topic.
I will make a relational database my creating multiple tables and
linking them together through if they both a particular fields By
doing this it will allow my end user to find certain data from
different tables., for example they could type in the CD name which
would be in one table and it would then tell them the songs on that
album which would be stored on another table.

Now that I know what I'm using to create my database I need to know
where and how I'll get my information.

I will need the information that my end users wants to put on to their
database such as: Artist name, album name, number of songs, Album
rating, artist rating and the length of each CD. I will collect this
data from CD's that my end user wants me to add to the database. I
will do this by keying in the necessary information I need from each
CD since I have no other means of inputting the data.

I will sort all of my information in alphabetical order by artist name
because I believe this will make it the easiest way of using the
database and it will help lower the amount of errors. Other ways I can
sort my data is ascending or descending by the number of songs or by
the length of the album but this would cause great confusion because
it would mean that you would need to know the time of the album (or
number of songs) to find the particular album or artist you are
looking for.

Input

Data Item

Data Type

Data source

Source Format

Entry Method

CD name

Text

CD

Paper

CD artist

Text

CD

Paper

How to Cite this Page

MLA Citation:
"The Creation of a Relational Database Using Microsoft Access." 123HelpMe.com. 18 Jan 2020
    <https://www.123helpme.com/view.asp?id=150436>.

Need Writing Help?

Get feedback on grammar, clarity, concision and logic instantly.

Check your paper »

Essay on Database Model Of Column Family Database

- • Key-Value Stores Key-value stores are designed for storing data in flexible and schema-less way. In these databases, data is stored as a list of keys with their corresponding values. All keys are unique and data access is achieved by means of key-value association. In addition, all keys are stored in a hash table to provide quick access for them. Values may contain actual information (raw data), or they may contain another set of keys. Key-value stores provide high concurrency, fast lookups and massive storage....   [tags: Database, Relational model, Relational database]

Research Papers
707 words (2 pages)

Relational Databases And Non Rational Databases Essay

- During my research, I discovered three database trends. The first trend bridges relational and non-rational databases together. The second trend offers databases in the cloud as a service. Lastly, the third trend is the focus for increased database security. Each trend aims to improve databases and the capabilities and services that they provide due to increasing demand and expanding needs. The author discusses while relational databases will be around for quite a while, their overall peak may be on the decline due to non-relational databases....   [tags: Database, SQL, Relational model, Relation]

Research Papers
1077 words (3.1 pages)

Essay about Relational Database Management System For A Cloud Application

- Relational Database Management System for a Cloud Application Lakisha Griffin University of Maryland University College Abstract While a lot of research is currently taking place in technology itself, there is an equally critical requirement for understanding the cloud computing issues. This paper examines “database-as-a-service” (DBaaS) called Relational Cloud. “A DBaaS promises to move much of the operational burden of provisioning, configuration, scaling, performance tuning, backup, privacy, and access control from the database users to the service operator, offering lower overall costs to users.” (Curino, 2011) Database management systems that control web application...   [tags: SQL, Database management system, Database]

Research Papers
1802 words (5.1 pages)

Database Analysis : Database And Information Systems Essay

- Database & Information Systems is a database used in everyday life, it was used in the past, is used in the present, and will continue to be used in the future. There are single and multiuser databases, as well as N Tier an client servers. There are many types of Data models such as, relational and star schema. Databases and information systems are even used on the web, these types can include PHP scripts and CGI scripts. To understand how Database & Information Systems came about, one has to look at the history of data....   [tags: SQL, Database, Relational model, Computer]

Research Papers
836 words (2.4 pages)

Essay on A Note On Database Management System

- In the web space where vast amounts of data is processed and collected, it is typical to store this information in a database. A common form of database is an RDBMS (Relational Database Management System). The act of retrieving and/or storing data to or from an RDBMS is called a transaction (Connolly and Begg, 2014). Connoly and Begg go on to outline the process in which these transactions are applied, by way of a COMMIT or ROLLBACK SQL statement, which are also written to a transaction log and may be used in the event of a systems failure to restore the database to a point prior to the failure....   [tags: SQL, Database, Relational model]

Research Papers
1079 words (3.1 pages)

Relational Database Management System Essay

- Relational Database Management System Oracle provides a flexible RDBMS called Oracle7. Using its features, you can store and manage data with all the advantages of a relational structure plus PL/SQL, an engine that provides you with the ability to store and execute program units. The server offers the options of retrieving data based on optimization techniques. It includes security features that control how a database is accessed and used. Other features include consistency and protection of data through locking mechanisms....   [tags: Database Data]

Research Papers
1093 words (3.1 pages)

Database in Distributive Environment Essay

- Database in Distributive Environment Database is a diverse collection of information which manages data and allows fast storage and retrieval of that data. Each application requires database to hold the data specific to the application, which is accessed by the users. However, each application according to its requirement needs different type of database. Researchers classify the databases according to the user specific functionalities, parameters as well as application. There have been several discussions and researches on the joins, which is a key performance indicator of any database....   [tags: cloud theory, paralell database]

Free Essays
536 words (1.5 pages)

Database Administration Roles Essay examples

- 1.0 DBA Roles: DBA plays important role in every organization, they are the core part of Technology Team, based on Organization DBA roles vary but majority of their role are very critical due to impact, Architect, Quality Analyst, System Analyst and Developers everyone has to work with DBA during different development life cycles. DBA skills are hard to find majority of organization prefer DBA which are certified, and certification for DBA are hard to achieve. Organization Expectation from DBA: - DBA should have good understanding of Database and its tools....   [tags: Database Administration Essays]

Free Essays
941 words (2.7 pages)

Database Environment Classification Essay

- Introduction: Database environment can be classified into three simple categories: a. Human: Database Administrator - They are responsible to monitor and maintain the databases in an organization. Systems Developers - They are responsible for the development of the computer applications which will talk to the database in do the necessary operations and display the results to the end users. b. Machine: User Interface - This is how the computer application looks and what the end user will use to interact....   [tags: human, machine, database]

Research Papers
1389 words (4 pages)

Relational Database Model Essay

- Comparing and Contrasting the Relational Database Model and OO Model The relational database model is based upon tables or relations. In this model, the physical implementation of the database is abstracted away from the user. Users query the database using a high-level query language, such as SQL. The relations are made up of columns, which have headings indicating the attribute represented by that column. Tables have key fields, which can be used to identify unique records. Keys relate tables to each other....   [tags: essays research papers]

Free Essays
931 words (2.7 pages)

Related Searches

Name of songs

text

CD

Paper

Number of songs

Number

CD

Paper

Album rating

Text

End user

Paper

Artist rating

Text

End user

Paper

Time of CD

Number

CD

Paper

Data Flow Diagram

Data Item

Recipient

Format

Output Method

Notes

Queries

End user

Visual display or print outs

A way to obtain specific data in a specific table

Reports

End user

I shall use the print button.

Printouts

A more professional looking way of results of a query

Forms

Look at the screen

Visual display

An easy way of viewing an inputted table and its data.

Mail Merge

Music shop owners

I shall use the print button

Print outs

Letters to be sent off.

Visual Display

End user

Look at the screen

Visual display

An easy way of viewing the database

I will make print outs once a week.

Backup

For a back up file I will save the database onto my own personal
computer so that if any thing goes wrong with the end users computer I
can simply save the database to a portable hard drive and transfer the
database to the end users computer. I will also make sure that the
back up is kept up to data so that if I or the end user were to edit
the database on the end users computer and it was to become lost or
corrupt then we wouldn't have to then go and manually update the back
up. This backup system is fairly simple and safe to use.

Security

For the end users security I will put the database system into a
protected folder so that to access or delete the folder the end user
will have to enter his personal password to get into the database.
This again is a simple way to keep the database protected, not that it
would really need protecting anyway because if the database was to be
accessed and changed or deleted we could simply replace it with a back
up.
Return to 123HelpMe.com