Topics: SQL, Data modeling, Relational model Pages: 6 (1251 words) Published: April 21, 2013
Database concepts| Assignment 1|
Robyn Wright|


Task 13
1.1Definition of database management system3
1.25 Advantages of database management system3
1.33 Business functions database management system could do3
1.45 database management system packages3
1.510 Factors when choosing a database management system3
Task 25
2.1Create a database if it does not yet exist5
2.2Show if the database has been created5
2.3Use a specific database5
2.4Delete a database5
2.5Create a table with columns5
2.6Insert information into a table5
2.7Extract certain information from a table6
Task 37
3.1The eight stages of the database design process7
Reference List10

A database is a group of information that is stored in a computerised way for easy access, organization and reupdating (2013). Databases can be used in many different ways and in many different companies. In this assignment we see how a database can fit into a law firm.

Task 1
1.1Definition of database management system
Software that allows a computer to perform database functions of storing, retrieving, adding, deleting and modifying data (Mike Chappel, 2012).   1.25 Advantages of database management system
1. Minimized data inconsistency – In a properly designed database, the chance of finding inconsistency within the data becomes very slim.
2. Less redundancy – Inside the database, the data is only recorded in one part of the database. This reduces the amount of redundancies (or copies) of the data as well as save storage space (2012).

3. Backup and Recovery Procedures – The data is backed up regularly to protect the data from being lost due to power failures, lightning etc.

4. Security – Will only allow people who are authorized to get access to the data as well as update and retrieve data. This minimizes the chance of data getting to people who are unauthorized access the data (2013).

5. Sharing – If people have authorization, they can access the information from other locations. Many people can have access to the same set of data at the same time. The data can also be shared between certain programs.

1.33 Business functions database management system could do 1. Show upcoming court cases
2. Retrieve case files faster
3. Search through the information to locate specific information, ex, searching for similar case 1.45 database management system packages
1. Microsoft SQL server
2. MySQL
3. Oracle
4. Sybase
5. IMB Informix
1.510 Factors when choosing a database management system
1. The price of the database
2. The features comply with what is needed
3. Supported programming language
4. The scalability of the database
5. The transportability of the database
6. Can it contain the information I need to use it for
7. Does it work on the operating system used in the company 8. The platform and the database comply with each other
9. It performs well, is not known to have many, to no problems 10. Decide on the type of database that is needed

Task 2
2.1Create a database if it does not yet exist
Create database if not exists bransonclientdb;

2.2Show if the database has been created
SHOW DATABASES LIKE ‘bransonclientdb’;

2.3Use a specific database
USE bransonclientdb;

2.4Delete a database
DROP DATABASE bransonclientdb;

2.5Create a table with columns
CREATE TABLE client (clientNumber int(11) not null, clientLastName varchar(45) not null, clientFirstName varchar(45) not null, Title varchar(5) not null,...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • database Essay
  • Database Design: Notes Essay
  • Essay about Database Concepts
  • Database for Scheduling Essay
  • Oracle Database: SQL Fundamentals Essay
  • Database management system notes Essay
  • Essay on Database Security and Encryption: A Survey Study
  • Database Synchronization with the Microsoft Sync Framework Essay

Become a StudyMode Member

Sign Up - It's Free