Three tier architecture -DBMS - Computer science fundamentals tutorial

Client server architecture (explains the client server architecture of DBMS/explains three tier architecture of DBMS)

Client server architecture is an architectural deployment style that describes separation of functionality into layers with each segment being tier that can be located on a physically separate computer. A client server architecture separate its tier from each other based on the complexity of user and how they used the data present in the database. It is the most widely used architecture to design a DBMS. Client server architecture are divided into three part. Three part are A) Database tier B) Application(middle) tier C) Presentations (user) tier

A.Database tier: - At this tier database resides along with its query processing languages. We also have the relation that define the data and their constrains at this level.

B.Application (middle) tier: - At this tier reside the application server and program that access database. For a user this application tier presents and abstracted view of database. Hence application tier/layer sits in the middle and acts as mediator between the end user and database.

C.Presentations (user) tier: - End users operate on this tier and they know nothing about any existence of database beyond this layer. At this layer multiple views of the database can be provided by application. All views are generated by application that resides in application tier.

Comments

type casting in C. - computer science fundamentals tutorial

Typecasting in C Typecasting is also known as "forced conversion". It refers to changing variable one data type to another data type. Typecasting in can be certified into following two types: - 1) Implicit type casting. 2) Explicit type casting. Implicit type casting : - It is also known as "Automatic type conversion". It is done by compiler on its own without any external trigger from user. Generally takes place when in an expression more than one data type is present in such condition. Type conversion take places to avoid data lose. Example : - #include<stdio.h> main() { char y = 'a'; int b = y; printf("%c",y); printf("%d",b); } Explicit Type casting : - This process also called 'Type casting' and it is user defined . Here the user can type cast the result to make it of particular data type. Example : - #include<stdio.h> main() { int m

Important MCQ of RDBMS( Relational database management system)-FCST

Important MCQ of RDBMS 1. A RDBMS consists a collection of ? a. Tables b. Fields c. Records d. Keys ANS/- a. table 2. The term attribute refers to a ___________ of a table a. Record b. Tuple c. Column d. Key ans/- c. Column 3. In relational model, the row of table is known to be ? a. Relation b. Entity field c. Tuple d. Attribute ans/- C. Tuple 4. . Address field of a person should not be part of primary key, since it is likely to ? a. Dependent b. Too long c. Changed d. Not changed ans/- c. Changed 5. The relational model is concerned with ? a. Data structure and Data integrity b. Data Manipulation c. Both a and b d. None of these ans/- c. Both a and b 6. Which is the false statement from the following ? a. A veiw is a named derived table b. A name relation is variable c. A veiw is a named reation and is virtual d. None of these ans/- d. None of these 7. The union of primary keys of the related entity sets becomes a

Solve-write C program to find grade of student by using nested else-if statement

C program to find grade of student by using nested else-if statement Problem Description This program take input as your number then show your grade. Problem Solution 1. enter your marks as input. 2. then check your marks with 'If' block's condition. if it satisfied then show your grade as output. 3. if it not satisfied then it checks with all else-if block's condition repeatedly. 4. print the grade according to your given marks as input and exit. Program codes:- #include<stdio.h> main() { int n; printf("\n enter the marks:"); scanf("%d",&n); if(n>89) printf("O"); else if(n>79) printf("E"); else if(n>69) printf("A"); else if(n>59) printf("B"); else if(n>49) printf("C"); else if(n>39) printf("D"); else printf("F"); } Program explanation:- 1. enter your marks. for example we take 70 .

Fundamentals of computer science tutorial (FCST)

Search This Blog