We use cookies to give you the best experience possible. By continuing we’ll assume you’re on board with our cookie policy

Database Report Essay Sample

essay
  • Pages: 3
  • Word count: 636
  • Rewriting Possibility: 99% (excellent)
  • Category: database

Get Full Essay

Get access to this section to get all help you need with your essay and educational issues.

Get Access

Introduction of TOPIC

In this report I will show how I created my own database so you can also create your own database following these simple steps that I will guide you through.

How to set a Drop down list:

How to set the primary key:

How to set the Input Masks:

How to set the Data Validation:

Relationship:

I have completed my tables now I need to make a relationship between them, we use relationships to link tables. This is done so that the details in the table can easily link up.

The purpose of a Relationships

The purpose of a relationship is to link tables together by a specific filed that consists in both tables.

I linked the “Costumers Details” table with the “Lending Details” by the “Account no”. This is called a one too many relationships because there could be only one “Account no” in the “Costumers Details” table per costumer but in the “Lending Details” table the same person can take as many loans as they like. I linked the othe

r two tables by the “Loan ID” this was also a one to many relationship because each loan

Sorry, but full essay samples are available only for registered users

Choose a Membership Plan
in the “Loans Available” table can have only contain one “Loan ID” while the “Lending Details” table can have several; this is because many people may open the same type of loan which contains its ID number.

Forms:

Queries and Reports:

Simple Queries:

Finding the customer with the “Account number” 1:

Finding the customers with an Occupation:

Finding the customers which are male:

Finding the customer with a surname called (Khan):

Finding the customer with the “Loans Id” 1:

Finding the customer with the “Lending Id” 5:

Complex Queries:

And Query:

Finding the customer with the “Account number” 3 and who is also female:

Finding the customer with an occupation and also whose age is 21:

Or Query:

Finding the customer with an age of 21 or a postcode beginning with “BD2”:

Finding the customer with an occupation or a gender of male:

Not Query:

Finding the customers who are not female:

Finding the customers who have an occupation:

My Queries:

My Reports:

When you have chosen the query and have entered the information you are looking for, to run the query you have to click an icon that looks similar to an explanation mark which is located on the top toolbar.

Switchboard

A database Switchboard is a unique type of Form that can be used to navigate around the various inputs or output documents generated by the database.

How to create a switchboard

The purpose of my switchboard is to make life easy for the employees or the receptionist that input new information like adding new customers, this switchboard will allow them to enter the new information without any hassle at all.

We can write a custom essay on

Database Report Essay Sample ...
According to Your Specific Requirements.

Order an essay

You May Also Find These Documents Helpful

What is the difference between controlled and...

Controlled redundancy is the state to improve the performance of queries. We want to control redundancy and retrieve the data along with the all the details. By placing all the data together, we do not have to search multiple files to collect this data. In some cases, the DBMS should control this redundancy in order to prohibit inconsistencies among the files. A controlled redundancy is a necessary technique to use redundant fields in a database. When a record showed that is inconsistent with the data file and when the DBMS has no control over this, we have uncontrolled redundancy. An example, of controlled and uncontrolled redundancy, is if you put in a document please enter your name and the input could be numbers, symbols, letter and multiple letters with a maximum of x things. But we could have controlled redundancy and put a rule where we only allow 12 letter...

Database Design

Introduction Every Weekend I rent a Video or DVD from my local videostore in Dungannon, and when I ask about new releases the employee behind the desk sits rummaging through lots and lots of file paper. I can see where they have taken down details of the person renting the filming in one column and in another the film number. I think they would be better off with a computer, so I put that idea to them and they said, "how would a computer help us?" so I would like to give them my answer by designing a database for them that not only is organised but very secure. Explanation of databases and why they would be of use to this system What is a database? A database is a collection of information put together in an organised way so that it is easy to retrieve. The first databases systems...

Implementation of my Database for Emma's DVD...

Emma's DVD rental shop in Birmingham. It started in 2008. It started in Birmingham by Emma's Pegg. When I later then realised that there was a gap in the market in the area. Originally I rented out films and computer games but the popularity of DVD'S increased rapidly in the years I decided to start my own business as a DVD renter. At the moment I work in the business shop myself and employ four assistants so that the shop can be open from 9am until 10pm everyday. I do not have a computer system setup at the moment and rely on that the paper based things to keep records of DVD'S and the people who have borrowed them. I have to be careful that DVD'S are rented out in good condition, so that they will be returned I can see if the member has scratched or marked them in...

Popular Essays

logo

Emma Taylor

online

Hi there!
Would you like to get such a paper?
How about getting a customized one?