Question

Give an example of a situation(scenario) where you need to use a database to store data. Explain clearly. (Min 500 words)

Subject:Database System

urgent

Answer 1

Solution:

Data:

Data is nothing but represents the information and can be qualitative or quantitative.

The qualitative data consists of descriptive and text data.

The quantitative data consists of numeric data,count or the result of some meathematical calculations.

The data in order to make it useful, it is necessary to store it and process it.

This helps in making decisions for our organization.

The major goal of any information systems is to transform the data to some other form to generate the useful knowledge that can be used by organization.

In order to achieve this, put the data into context and use the tools for operations like aggregation and data analysis.

Database:

A database is basically a organized collection of related information.

All the information in the database should be related to each other data in it.

Various types of databases are present.The mostly used databases are the Relational databases.

This consists of the data that is stored in the tables.

Mostly used relational databases are Mysql, Oracle, MS Access etc...

Each table has various fields in it. These fields are used to store the tabular data in it.

Various tables are used for a database schema to eliminate the redundancies.

Example:

Consider the scenario where a university wants to maintain a information system, where the database stores the information about the student clubs.

The idea to implement and design the data base is that the way the university funds the clubs is identified.

The database must store the details of how many members and students are present in each club and how active the clubs are.

The events that are held by each club must be noticed.

All these related information to the clubs must be stored in the databases.

In order to store the above information, the following tables must be created.

The tables are Clubs,Students, Memberships, Events.

These tables store the details of the students and the clubs present in the university.

The fields that must be present in each table must be noticed.

Each table has its own respective primary keys and the foreign keys that are used to relate to each other table.

In the clubs table, the club name would be the important field.

In the students table, the first name, last name, and the clubs in which the student is present must be stored.

As the details are stored in the tables, it must be stored that each table must have some field in common with the other tables.

They should have a relationship with all the other tables to identify the related information needed.

In order to create this relationship, the primary keys are used for each table and are used to relate to other table in the database.

The following image consists of the tables and the fields in it.

It shows the primary keys and the details of how the tables are connected to each other.