Database

DBDC11D| Database concepts| Assignment 1| | Robyn Wright| 3/27/2013| | Contents Introduction2 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. Insert information into a table5 2. 7Extract certain information from a table6 Task 37 3. 1The eight stages of the database design process7 Conclusion9 Reference List10 Introduction 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 t his assignment we see how a database can fit into a law firm. Task 1 1. 1Definition of database management systemSoftware 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. om/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 retri eve 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.Database Management System and DataMany 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 . Supported programming language 4. The scalability of the database 5. The transportability of the database 6. Can it con tain 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’; . 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, TellephoneNum varchar(10) not null, CellNum varchar(10) not null, primary key (clientNumber)); 2. 6Insert information into a table INSERT INTO client VALUES (‘001’,’Boehm’,’Barry’,’Mr’,â₠¬â„¢0123456789’,’0831235657’); 2. 7Extract certain information from a table SELECT * FROM overdueWHERE OutstandingAmount >1200 ORDER BY clientFirstName; Task 3 3. 1The eight stages of the database design process Step 1: Purpose of the database This is where the information/ data for the database is found. We locate the information as well as decide on the database type, what database to use. We would use the following item to help in this step: Business rules (to understand what the table names could be). Example of information found in this step would be: using MySQL, the model structure, planning for the next steps Step 2: Data informationThis is the step where all the information is organized. We organize it into required information and not required, into names, surnames, ID number – this is to get column names for our tables. Note that nothing has been created yet. Example of information found in this step: client_ID; client_first_name; client_last_n ame. Step 3: Table sorting and structure This is the step where we begin to create a database. We start creating entities and table structures. This is the base, or foundation of the database, nothing can exist without it.Examples of what is found in it: a table named court_dates, or a table named client_lists Step 4: Columns and records In this step we input at the information into the tables. We firstly enter all the relevant fields or columns and then we enter the information into the relevant fields. What can be found: a table Step 5: Primary Keys This step, is where we, inside the table define which column will become the primary key for the table. Here is an example of a statement setting a primary key (red block) The primary key helps to identify rows Dr. Croft, N. (2013).An example of a primary key is: clinet_id Step 6: Relationships In this step, we define how tables are related to each other. If it is a one to one, one to many or a many to many. It is a way to define what data in one table is related to in other tables. Example would be a one to many. Step 7: Design Revisions We check for any design flaws in this step, add foreign keys and add adjustements to the design where needed. Example: Adding foreign keys Step 8: Normalization In the last and final step we check for errors in our tables, we make sure they are structured correctly and are removed of all redundant behaviour.Conclusion In this assignment I have learnt how to navigate the basics of MySQL. I learnt how to add information and select information from a database. I learnt about the reasoning behind creating a database and why it is a better choice than that of a paper based nature. Reference List Administrator (2013)  Advantages and disadvantages of DBMS. [online] Available at: http://www. myreadingroom. co. in/home/226. html [Accessed: 23 Mar 2013]. Dr. Croft, N. (2013)  Database Design Concepts. Johannesburg : CTI Education Group. Navdeep19. blogspot. om (2012)  Excellence: Ad vantages and Disadvantages of Database Management System (DBMS). [online] Available at: http://navdeep19. blogspot. com/2012/04/advantages-and-disadvantages-of. html [Accessed: 23 Mar 2013]. Chapple, M. (2012)  Database Management System. [online] Available at: http://databases. about. com/od/administration/g/dbms. htm [Accessed: 19 Feb 2013] Searchsqlserver. techtarget. com (2013)  What is database? – Definition from WhatIs. com. [online] Available at: http://searchsqlserver. techtarget. com/definition/database [Accessed: 26 Mar 2013]