Database Management System Grade X DBMS Database Management

Database Management System Grade: X DBMS (Database Management System) limitless opportunities in learning info@brushuponline. edu. np Brush-Up Online www. brushuponline. edu. np

Database Management System Data and Information The unprocessed raw information is known as data. It can be numbers, letters, word or any symbols representing facts and figure that may not have significant meaning by itself. For example, Raj and 10 have no significant meaning. The collection of organized related processed data which has significant meaning is called information. For example, “Raj is a student. He studies in class 10”, have significant meaning. info@brushuponline. edu. np Brush-Up Online www. brushuponline. edu. np

Database Management System Database The collection of organized interrelated data/information to any subject or purpose is known as database. It is used to store, organize and extract data. Database can be computerize and non-computerize (manual). A database may have single table or multiple tables. The data in a database are organized in rows and columns. Examples: Telephone directory, mark ledger, attendance register, dictionary etc. info@brushuponline. edu. np Brush-Up Online www. brushuponline. edu. np

Database Management System (DBMS) is a method that stores data process them and provide information in an organized form using database management software. It also allows the user to modify, update organize and retrieve information from the database. Examples : q MS-Access q Oracle q Fox. Pro q MS SQL Server q My. SQL q d. Base info@brushuponline. edu. np Brush-Up Online www. brushuponline. edu. np

Database Management System Features/Advantages of DBMS • Large volume of data can be stored and updated easily • It provides data integrity and security • Easy in data administration or data management • It provides the data sharing facility • It reduces the data redundancy (duplication of data) • Provides concurrent access, recovers the data from the crashes • Centralized control info@brushuponline. edu. np Brush-Up Online www. brushuponline. edu. np

Database Management System Disadvantages of DBMS • Problem associate with centralized • Cost of software, hardware and migration • Complexity of backup and recovery info@brushuponline. edu. np Brush-Up Online www. brushuponline. edu. np

Database Management System Relational Database Management System (RDBMS) is most widely used software or program that stores database in multiple tables on the basis of a key field. It allows a user to view or retrieve records from the multiple linked tables continuously at a time. Examples : q MS-Access q Oracle q My. SQL q MS SQL Server info@brushuponline. edu. np Brush-Up Online www. brushuponline. edu. np

Database Management System Microsoft Access (MS-Access) MS-Access is a Relational Database Management System developed by Microsoft Corporation. It is used to store and manipulate large amount of data in the form of tables. It allows the user to create database and store data in multiple tables. Objects of MS-Access are: ü Table ü Query ü Form ü Report ü Pages ü Macro ü Modules info@brushuponline. edu. np Brush-Up Online www. brushuponline. edu. np

Database Management System Features of MS-Access Ø Create sophisticated database quickly. Ø Analyze and modify your data easily with queries. Ø Create elaborate reports from your data. Ø Make customized data entry forms. Ø Present your data dynamically on World Wide Web. info@brushuponline. edu. np Brush-Up Online www. brushuponline. edu. np

Database Management System Table is primary object or building block of database that stores large volume of data in the form of rows and columns. A single table is used to store data of a specific purpose or subject. For different example: ways to create a table in Ms-Access Table The are: ü Create table in Design view ü Create table by using Wizard ü Create table by entering Data info@brushuponline. edu. np Brush-Up Online www. brushuponline. edu. np

Database Management System Elements of Database Field A column of a table which stores a particular type of data is known as a field. It is the smallest unit of the database. It is also known as attribute. For example: info@brushuponline. edu. np Field Brush-Up Online www. brushuponline. edu. np

Database Management System Elements of Database Record The collection of multiple related fields in a row is known as record. It gives complete information about a person or thing. It is also known as tuple. For example: Record info@brushuponline. edu. np Brush-Up Online www. brushuponline. edu. np

Database Management System Table Relationship The logical linkage between two or more than two tables with the help of unique key field is known as relationship. To prevent the duplication of information in a database by repeating fields in more than one table, table relationships can be established. The types of table relationship are: • One - to - One • One - to - Many • Many - to - Many info@brushuponline. edu. np Brush-Up Online www. brushuponline. edu. np

Database Management System Primary Key is a special field in the table that uniquely identifies each record from the database. The primary key does not accept duplicate value for a field and it does not allow a user to leave the field blank or null. The importance of primary key • To identify each record of a table uniquely within very short time. • To reduce and control duplication of the record in a table. • To set the relationship between tables. Foreign Key Foreign key is a field in a relational table that matches the primary key column of another table. info@brushuponline. edu. np Brush-Up Online www. brushuponline. edu. np

Database Management System Data Type A data type is a feature of a field that determines the kind of data that can be stored in the field. Each field can store data relating of only a single data type. OLE object Currency Hyperlink Attachment Date/Time Memo Lookup Wizard Text Yes/No Number Auto. Number OLE Object data type allows pictures, graphs, sound, video Attachment Currency Hyperlink Date/Time data is type used type tostores attach stores only any currency hyperlink date documents and value. time addresses or Itsany value. other Its ofis 8 Memo Lookup data Wizard type isdata also type displays alphanumeric the data characters from another Text data type is default data type ofvalue Ms-Access. Itstorage stores Yes/No data stores aonly logical that can be only Number Auto. Number data type data stores type only generates numeric unique values. sequential Long etc. Its storage is up to 1 such GB. bytes. documents. file storage in the size table. It ischaracters. stores 8 size bytes. up toor 2048 characters. up table to 65, 535 by using list box It. The combo is used box. for. Yes/No, long Itsstorage text. True/False, such size asofis 4 alphanumeric characters. maximum size one of values as integer number istwo automatically. thepossible default number Its storage data type size is in 4 MS-Access. bytes. remarks, bytes. comment etc. characters text dataetc. type. Itsisstorage 255 and default size is 50 in On/Off size is 1 bit. MS-Access 2003. info@brushuponline. edu. np Brush-Up Online www. brushuponline. edu. np

Database Management System The common field properties Field Size Text Validation Caption It specifies allows a the usermessage to set the of to bemaximum displayednumber to the user It allows a user to set an alternate name for the field. characters thatenter can be in aisfield. when the data in stored the field not matched to the It can contain up to 2048 characters. validation rule. Format It allows. Value a user to specify the appearance of the Required Default value whenthe displayed. It specifies whether be entered in a field It specifies valuedata that must is automatically in or not. a field when a new record is added. Input Mask Indexed Validation Rule It specifies a pattern and controls the value of a It speeds searching sorting records based controlup and limit theand values thatofcan be accepted record for all data to be entered in the field. on intoa afield. info@brushuponline. edu. np Brush-Up Online www. brushuponline. edu. np

Database Management System Query is an object of database that is used to view, retrieve, change and analyze records from a table or multiple linked tables based on specified condition. When a user changes data in the query, the data in the table also changes. It can use as a source of records forms and reports. The types of query are: • Select query • Action query Select query is a most common type of query that retrieves data from one or An action query is also type of query that makes changes or updates many more tables and displayed the result in a datasheet. You can also use a select records in just one operation. The different types of action queries are: query to group records and calculate sums, counts and average, minimum, i) Delete query ii) Update query and maximum. iii) Append query iv) Make - Table query info@brushuponline. edu. np Brush-Up Online www. brushuponline. edu. np

Database Management System Form is a type of database object that is primarily used to create an interface for entering data in a table or multiple linked tables. A form displays a complete record at a time, so it is more convenient to view and modify record through the form. Different ways to design form are: • Creating form using Design view • Creating form using Auto form • Creating form using Form wizard info@brushuponline. edu. np Brush-Up Online www. brushuponline. edu. np

Database Management System Report is a type of access database object that present data in effective way in a printed format. It allows a user to print documents according to the user specifications of the summarize information through queries or tables. Different ways to design form are: • Creating form using Design view • Creating form using Form wizard info@brushuponline. edu. np Brush-Up Online www. brushuponline. edu. np

Database Management System Basic Database Terms Entity is the distinguishable objects of real world. For e. g. Student, customer, employee. Attributes They are the set of properties possessed by an entity. E. g. Name, address, contact no of student. Tuple Each record row in a table is tuple. info@brushuponline. edu. np Brush-Up Online www. brushuponline. edu. np

Database Management System Basic Database Terms Sorting The process of arranging all the records in a table either ascending or descending order based on field or fields is known as sorting. Filtering The process of viewing required record of a table that matches the specified criteria is known as filtering. Formatting the table The process of changing the appearance of a table using different options is known as formatting the table. For example, change the column width, row height, hiding columns, changing the font, style and size of the text and table border etc. info@brushuponline. edu. np Brush-Up Online www. brushuponline. edu. np

Database Management System Database Administrator (DBA) An information specialist who has responsibility for the database is called a Database Administrator (DBA). His/her duties fall into four major areas: Database planning, implementation, operation and security. info@brushuponline. edu. np Brush-Up Online www. brushuponline. edu. np

Database Management System Question and Answer Session info@brushuponline. edu. np Brush-Up Online www. brushuponline. edu. np