Database

DBDC11D Database concepts Assignment 1 Robyn Wright 3/27/2013 Contents Introduction2 Task 13 1. 1Definition of entropybase watchfulness governance3 1. 25 Advantages of infobase perplexity system3 1. 33 traffic 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 inhabit5 2. 2Show if the database has been created5 2. 3Use a specific database5 2. 4Delete a database5 2. 5Create a duck with columns5 2. Insert info into a table5 2. 7Extract veritable culture from a table6 Task 37 3. 1The ogdoad stages of the database name process7 Conclusion9 quality List10 Introduction A database is a group of information that is stored in a computerised bureau for easy access, organization and reupdating http//searchsqlserver. techtarget. com/definition/database (2013). Databases arouse be employ in numerous different shipway and in many di fferent companies. In this 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 normaled database, the chance of determination inconsistency within the data becomes very slim. 2. Less redundancy Inside the database, the data is only preserve in one part of the database. This reduces the amount of redundancies (or copies) of the data as healthful as save reposition 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 the great unwashed who are authorized to get access to the data as wel l as update and convalesce data. This minimizes the chance of data getting to people who are unauthorized access the data http//www. myreadingroom. co. in/ stem/226. html (2013). 5. Sharing If people have authorization, they can access the information from new(prenominal) locations.Database perplexity corpse 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. under organize 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 . 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, radical key (clientNumber)) 2. 6Insert information into a table INSERT INTO client VALUES (001,Boehm,Barry,Mr,0123456789,0831235657) 2. 7Extract certain i nformation 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 utilize 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 nada has been created yet. Example of information found in this step client_ID client_first_name client_last_name. Step 3 Table sorting and structure This is the step where we begin to create a datab ase. 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 palm 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 decide which column will become the firsthand 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 fig 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 calibration In the last and final step we check for errors in our tables, we make sure they are organise correctly and are removed of all redundant behaviour.Conclusion In this assignment I have learnt how to fly the basics of MySQL. I learnt how to add information and select information from a database. I learnt about the ratiocination 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 Advantages 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