'Database\r'

'DBDC11D| Database concepts| grant 1| | Robyn Wright| 3/27/2013| | card of contents accounting entry2 occupation 13 1. 1Definition of entropybase circumspection transcription of rules3 1. 25 Advantages of infobase guidance dodge3 1. 33 Business functions studybase management system could do3 1. 45 infobase management system packages3 1. 510 Factors when choosing a database management system3 Task 25 2. 1Create a database if it does non til now constitute5 2. 2Show if the database has been take a crapd5 2. 3Use a specific database5 2. 4Delete a database5 2. 5Create a flurry with mainstays5 2. Insert reading into a knock back5 2. 7Extract plastered grantive information from a dishearten6 Task 37 3. 1The eighter stages of the database design process7 Conclusion9 Reference describe10 Introduction A database is a group of information that is stored in a computerised way for informal ingress, organization and reupdating http://searchsql waiter. techtarget. com /definition/database (2013). Databases clear be physical exercised in m some(prenominal) distinct ways and in many disparate companies. In this identification we see how a database bunghole fit into a truth firm. Task 1 1. 1Definition of database management systemSoftw be that whollyows 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 variety †In a by rights designed database, the chance of finding inconsistency within the data becomes very slim. 2. slight redundancy †Inside the database, the data is besides recorded in whizz touch off of the database. This reduces the amount of redundancies (or copies) of the data as closely as save storage infinite http://navdeep19. blogspot. om/2012/04/advantages-and-disadvantages-of. hypertext mark-up language (2012). 3. Backup and Recovery Procedures †The data is backed up reg ularly to comfort the data from being lost collectible to power failures, lightning etc. 4. Security †volition only allow people who argon authorized to get access to the data as well as update and retrieve data. This minimizes the chance of data get to people who be unauthorized access the data http://www. myreadingroom. co. in/home/226. hypertext markup language (2013). 5. Sharing †If people dedicate authorization, they can access the information from other locations.Database solicitude System and DataMany people can have access to the same set of data at the same time. The data can also be shared amidst certain programs. 1. 33 Business functions database management system could do 1. Show approaching court pillow slips 2. Retrieve case files high-velocity 3. Search through the information to square off 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 Info rmix 1. 510 Factors when choosing a database management system 1. The price of the database 2. The features comply with what is needed . support programming language 4. The scalability of the database 5. The transportability of the database 6. Can it stand the information I need to use it for 7. Does it work on the operating system used in the company 8. The program and the database comply with each other 9. It performs well, is non known to have many, to no problems 10. influence 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 acquaint DATABASES LIKE ‘bransonclientdb’; . 3Use a specific database habit bransonclientdb; 2. 4Delete a database DROP DATABASE bransonclientdb; 2. 5Create a table with pillars 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 headstone (clientNumber)); 2. 6Insert information into a table break in INTO client VALUES (‘001’,’Boehm’,’Barry’,’Mr’,’0123456789’,’0831235657’); 2. 7Extract certain information from a table SELECT * FROM overdueWHERE OutstandingAmount >1200 magnitude BY clientFirstName; Task 3 3. 1The eight stages of the database design process dance tonus 1: Purpose of the database This is where the information/ data for the database is found. We fold up the information as well as decide on the database type, what database to use. We would use the by-line item to help in this measuring: Business rules (to understand what the table names could be). compositors case of information found in this step would be: using MySQL, the feign structure, planning for the next steps mensuration 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. prototype of information found in this step: client_ID; client_first_name; client_last_name. stride 3: Table form 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 touchstone 4: Columns and records In this step we stimulation at the information into the tables. We firstly precede all the germane(predicate) fields or columns and then we enter the information into the relevant fields. What can be found: a table Step 5: old Keys This step, is where we, inside the table narrow down which column will become the primary pi ck out for the table. Here is an congresswoman of a literary argument setting a primary mark (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 mold for any design flaws in this step, add distant keys and add adjustements to the design where needed. Example: Adding contrasted 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 upstage of all redundant behaviour.Conclusion In this assignment I have learnt how to navigate the fundamentals of MySQL. I learnt how to add information and select information from a database. I learnt most the reasoning behind creati ng a database and wherefore it is a better choice than that of a paper based nature. Reference List Administrator (2013) Advantages and disadvantages of DBMS. [online] gettable at: http://www. myreadingroom. co. in/home/226. html [Accessed: 23 flub 2013]. Dr. Croft, N. (2013) Database Design Concepts. Johannesburg : CTI Education Group. Navdeep19. blogspot. om (2012) Excellence: Advantages and Disadvantages of Database trouble 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]\r\n'