You should see a Window similar to the one displayed below To open OpenOffice, click Start>Programs> 4 > .Īlternatively, you can also double-click on the 4 shortcut on the desktop if available.There are a variety of DBMS/RDBMS available in this exercise, you will learn about OpenOffice Base an Open Source RDBMS. Each row in a table represents a set of related data, and every row in the table has the same structure. In simple terms, a database table can be visualized as consisting of rows and columns or fields. For example, cFirstName, or cLastName are fields in a row.Ī row also called a Record or Tuple represents a single, data item in a table. The columns provide the structure according to which the rows are composed. Each row is identified by the values appearing in a particular column identified as a unique key index or the key field.Ī column is a set of data values of a particular simple type, one for each row of the table. A table has a defined number of columns, but can have any number of rows. A Relational database use Structured Query Language (SQL), which is a standard user application that provides an easy programming interface for database interaction.Ī table is a set of data elements (values) that is organized using a model of vertical columns(which are identified by their name) and horizontal rows. Tables communicate and share information, which facilitates data searcheability, organization and reporting. Relational database establish a well-defined relationship between database tables. You will now quickly recap what you learnt in the last session and assimilate more concepts.Ī relational database is a collective set of multiple data sets organized by tables, records and columns. Class 10 Information Technology Create And Edit Table Using Wizard And Sql Commands Notesĭata in a relational database management system (RDBMS) is organized in the form of tables. Students can so through the revision notes which will help them to get more marks in exams. These notes have been prepared based on the latest curriculum issued for the current academic year. Please refer to Create And Edit Table Using Wizard And Sql Commands Notes for Class 10 Information Technology.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |