Database concepts| Assignment 1|
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
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
3.1The eight stages of the database design process7
A database is a group of information that is stored in a computerised way for easy access, organization and reupdating http://searchsqlserver.techtarget.com/definition/database (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.
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 http://navdeep19.blogspot.com/2012/04/advantages-and-disadvantages-of.html (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 http://www.myreadingroom.co.in/home/226.html (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
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
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
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,...