DBMS

Question 1

What is data

Answer 1

Any fact that can be recorded or stored ,
various form of data is image file audio file text document

Question 2

What is a database

Answer 2

Program or software is you used to construct manipulate and retrieve the data in the database

Question 3

what is client

Answer 3

Computer which has client software installed in it.

Question 4

What is server

Answer 4

Computer which has server program installed in

Question 5

What are the various website hosting sites

Answer 5

1. GoDaddy,
2. inmotion,
3. siteground

Question 6

What is the difference between thermal program and DBMS

Answer 6

Server program response to client , but the DBMS fetch the required data from system and give it to the user

Question 7

Three important points of ERD ?

Answer 7

1. Entity
2. Relationship
3. Attributes

Question 8

What is mean by Relationship between two entities ?

Answer 8

Indicate Association between two entities

Question 9

What are simple attributes

Answer 9

Attribute can’t be divided for the ,
Or single value attributes , like Age

Question 10

What are composite attributes

Answer 10

Divide the attribute in sub names
Attribute that can be divided for like , name is divided in first name, last name

Question 11

What are single value Attributes

Answer 11

Those have single value in it

Question 12

What are multi valued attributes

Answer 12

Those have multiple values in it like phone number

Question 13

What are you stored attributes ?

Answer 13

We can only store value of this at at atttribute

Question 14

What is derived attribute

Answer 14

we can derive the value of these attributes from a stored attributes,
like age is derived from year of birth

Question 15

What is complex Attribute ?

Answer 15

And attribute which is both composite and multi valued , like Address attribute