Openoffice org base1/31/2024 You store the data in the database in the form of tables. Tables are the basic building blocks of a database. The Save As dialog box appears.Ĥ) Specify a name for the database in the File name: field and click Save. Creating Database Using OpenOffice :ġ) Open the OpenOffice Base Application by Clicking on Start>Programs> 4> Base.Ģ) Create a new database by selecting the option Create a new databaseģ) Database wizard appear. Every row in the table has the same structure. DATABASE OBJECTS :ġ) Table : A table is a set of data elements (values) that is organized using a model of vertical columns and horizontal rows.Ģ) Columns or Fields or Attributes: A column is a set of data values of a particular simple type, one for each row of the table.ģ) Rows or Records or Tuples : A row also called a Record or Tuple represents a single data item in a table. State the relationship and difference between a primary and foreign key? Click for Answers of above Questions - Click for more Questions and Answersĭatabase Management System Class 10 Notes SESSION-2 : CREATE AND EDIT TABLES USING WIZARD & SQL COMMANDSĭata in a relational database management system (RDBMS) is organized in the form of tables. It helps the database to search for a record.Ģ) Composite Primary Key : When primary key constraint is applied on one or more columns then it is known as Composite Primary Key.ģ) Foreign key : The foreign key identifies a column or set of columns in one (referencing) table that refers to a column or set of columns in another (referenced) table.ĭatabase Management System Class 10 Notes ASSESSMENT Fill in the blanks:ġ) A _ is an organized collection of data.Ģ) A _ is a software package that can be used for creating and managing databases.ģ) A _ is a database management system that is based on the relational model.Ĥ.Three popular DBMS software are _, _, & _ĥ) A _ _ is a unique value that identifies a row in a table.Ħ) Composite Key is a combination of _ columns. Important Terms :ġ) Primary Key : A primary key is a unique value that identifies a row in a table. Some key features of a database:ġ) A database can have one or many tables.Ģ) Each table in a database contains information about one type of item.ģ) Every table has a key field which ensures that there are 100% unique values throughout the database. Advantages of Database :ġ) Reduces Data Redundancy : Database reduces data redundancy (duplication of data)Ģ) Sharing of Data : In a database, the users of the database can share the data among themselves.ģ) Data Integrity : Data integrity means that the data is accurate and consistent in the database.Ĥ) Data Security : Database provides data security as only authorized users are allowed to access the database and their identity are authenticated by using a username and password.ĥ) Privacy : The privacy rule in a database states that only the authorized users can access a database according to its privacy constraints.Ħ) Backup and Recovery : Database Management System automatically takes care of backup and recovery. Relational is suitable for medium to large amount of data.ĭatabase servers are dedicated computers that hold the actual databases and run only the DBMS and related software. Relational : Data is stored in multiple tables and the tables are linked using a common field.Usually suitable for less amount of data. Flat File : Data is stored in a single table.for example Oracle, IBM DB2, Microsoft SQL Server, Microsoft Access, PostgreSQL, MySQL, FoxPro, and SQLite. Database Management System :Ī database management system is a software package with computer programs that controls the creation, maintenance, and use of a database. In the manual system, you would maintain several files with different bits of information while in the computerized system you would use database programs such as Microsoft Access, Base, and MySQL, to organize the data as per your business need. It is considered as a container of information. SESSION 1: APPRECIATE THE CONCEPT OF DATABASE MANAGEMENT SYSTEMĪ database is an organized collection of data. SESSION 1: APPRECIATE THE CONCEPT OF DATABASE MANAGEMENT SYSTEM SESSION 2: CREATE AND EDIT TABLES USING WIZARD AND SQL COMMANDS SESSION 3: PERFORM OPERATIONS ON TABLE SESSION 4: RETRIEVE DATA USING QUERY SESSION 5: CREATE FORMS AND REPORTS USING WIZARD Database management system class 10 notes UNIT-3 RELATIONAL DATABASE MANAGEMENT SYSTEMS (BASIC)
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |