<\/p>\n
DBMS Concept<\/b><\/p>\n
Database Management System (DBMS)<\/p>\n
A database management system (DBMS) is a program that lets one or more computer users create and access data in a database. A DBMS can be thought of as a file manager that manages data in databases rather than files in file systems. The DBMS provides integrity of the data, i.e., making sure data continues to be accessible and is consistently organized as intended and security making sure only those who have privileges can access the data. The DBMS manages user requests and requests from other programs so that users and other programs are free from having to understand where the data is physically located on storage media and, in a multi-user system, who else may also be accessing the data.<\/p>\n
Major functions of a database are:<\/p>\n
1. Creating records of various data types such as integer, real, character, etc.<\/p>\n
2. Query will be made by a standardized language such as SQL (Standard Query Language).<\/p>\n
3. Operation such as sort, delete, modify, select, etc.<\/p>\n
4. Manipulation such as input, output, analysis, reformatting, etc.<\/p>\n
5. Documentation such as metadata or description of the contents of the database should be compiled.<\/p>\n
<\/p>\n
There are four types of database models:<\/p>\n
1. Hierarchical model.<\/p>\n
2. Network model.<\/p>\n
3. Relational model.<\/p>\n
4. Object oriented model.<\/p>\n
A DBMS is usually an inherent part of a database product. Microsoft\u2019s SQL Server is an example of a DBMS that serves database requests from multiple clients (users). On PCs, Microsoft Access is a popular example of a single- or small-group user DBMS. Other popular DBMSs are IBM\u2019s DB2, Oracle\u2019s line of database management products and Sybase\u2019s products.<\/p>\n
<\/p>\n
Domain Relational Calculus<\/b><\/p>\n
Domain variables take on values from an attribute\u2019s domain, rather than values for an entire tuple. An expression is of the form:<\/p>\n
{ | Q(x1, x2,\u2026, xn)}<\/p>\n
Where the xi, 1\u2264 i \u2264 ni represent domain variables, and Q is a formula.<\/p>\n
1. An atom in the domain relational calculus is of the following forms:<\/p>\n
\u2022 \u20ac r where r is a relation on n attributes, and xi, 1 \u2264 i \u2264 n, are domain variables or constants.<\/p>\n
\u2022 x \u0398 y, where x and y are domain variables, and \u0398 is a comparison operator.<\/p>\n
\u2022 x \u0398 c, where c is a constant.<\/p>\n
<\/p>\n
2. Formulae are built up from atoms using the following rules:<\/p>\n
\u2022 An atom is a formula.<\/p>\n
\u2022 If Q is a formula, then so are Q and (Q).<\/p>\n
\u2022 If Q1 and Q2 are formulae, then so are Q1 V Q2, Q1 \u039b Q2 and Q1 => Q2.<\/p>\n
\u2022 If Q(x) is a formula where x is a domain variable, then so are x (Q(x)) and x(Q(x)).<\/p>\n
<\/p>\n
Tuple Relational Calculus<\/b><\/p>\n
A tuple relational calculus expression is of the form<\/p>\n
{t | Q(t)}<\/p>\n
Where Q is known as formula.<\/p>\n
We also use the notation<\/p>\n
\u2022 t[a] to indicate the value of tuple t on attribute a.<\/p>\n
\u2022 t \u0404 r to show that tuple t is in relation r.<\/p>\n
<\/p>\n
1. A tuple variable is said to be a free variable unless it is quantified by\u00a0 Then it is said to be a bound variable.<\/p>\n
2. A formula is built of atoms. An atom is one of the following forms:<\/p>\n
\u2022 \u03b4 \u0404 r, where \u03b4 is a tuple variable, and r is a relation (\u00a2 is not allowed).<\/p>\n
\u2022 \u03b4[x] \u0398 u[y], where \u03b4 and u are tuple variables, and x and y are attributes, and \u0398 is a comparison operator (<, \u2264 , =, \u2260, >, \u2265).<\/p>\n
\u2022 \u03b4[x] \u0398 c, where is a constant in the domain of attribute x.<\/p>\n
3. Formulae are built up from atoms using the following rules:<\/p>\n
<\/p>\n
An atom is a formula.<\/p>\n
\u2022 If Q is a formula, then so are Q and (Q).<\/p>\n
\u2022 If Q1 and Q2 are formulae, then so are Q1 V Q2, Q1 \u039b Q2 and Q1 => Q2.<\/p>\n
\u2022 If Q(\u03b4) is a formula containing a free tuple variable \u03b4, then<\/p>\n
\u03b4 \u0404 r(Q(\u03b4)) and \u03b4 \u0404 r(Q(\u03b4))<\/p>\n
are formulae also.<\/p>\n
<\/p>\n
3. Note some equivalences:<\/p>\n
\u2022 Q1 \u039b Q2 = (Q1 V Q2).<\/p>\n
\u2022 t \u0404 r(Q(t)) = t \u0404 r( Q(t)).<\/p>\n
\u2022 Q1 => Q2 = Q1 V Q2.<\/p>\n","protected":false},"excerpt":{"rendered":"
Data Base Management System Notes DBMS Concept Database Management System (DBMS) A database management system (DBMS) is a program that lets one or more computer users create and access data in a database. A DBMS can be thought of as a file manager that manages data in databases rather than files in file systems. … Read more<\/a><\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"","fifu_image_alt":""},"categories":[4773],"tags":[473],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.kopykitab.com\/blog\/wp-json\/wp\/v2\/posts\/29305"}],"collection":[{"href":"https:\/\/www.kopykitab.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.kopykitab.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.kopykitab.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kopykitab.com\/blog\/wp-json\/wp\/v2\/comments?post=29305"}],"version-history":[{"count":0,"href":"https:\/\/www.kopykitab.com\/blog\/wp-json\/wp\/v2\/posts\/29305\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.kopykitab.com\/blog\/wp-json\/wp\/v2\/media?parent=29305"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kopykitab.com\/blog\/wp-json\/wp\/v2\/categories?post=29305"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kopykitab.com\/blog\/wp-json\/wp\/v2\/tags?post=29305"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}