[go: up one dir, main page]
Scribd
Upload
40 views2 pages

l8 Data Base Concepts Ws-1 - std11

This document contains questions about database concepts, the relational model, MySQL, SQL, and sample tables to analyze relationships. It asks the learner to define key database terms, explain file-based limitations, database advantages, the relational model, and properties of relations. Questions also cover MySQL features and uses, the client-server model, SQL commands, and differentiating DDL and DML. Sample tables demonstrate identifying primary keys, composite keys, foreign keys, and unique attributes to analyze degree and cardinality.

Uploaded by

Hari
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
40 views2 pages

l8 Data Base Concepts Ws-1 - std11

This document contains questions about database concepts, the relational model, MySQL, SQL, and sample tables to analyze relationships. It asks the learner to define key database terms, explain file-based limitations, database advantages, the relational model, and properties of relations. Questions also cover MySQL features and uses, the client-server model, SQL commands, and differentiating DDL and DML. Sample tables demonstrate identifying primary keys, composite keys, foreign keys, and unique attributes to analyze degree and cardinality.

Uploaded by

Hari
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

DAV PUBLIC SCHOOL

L8 DATA BASE CONCEPTS (STD 11) SUB : IP WORKSHEET-1


1. Define Database

2. List the file –based limitations.

3. What do you understand by data dependency?

4. Explain data redundancy.

5. Explain any advantages of database.

6. Name some applications of DBMS.

7. What is database schema?

8. What is database engine?

9. Explain the term relation model

10. Define: a)relation b)tuple c) attribute d) degree e) cardinality

f) Primary key g) Candidate key h) alternate key i) Foreign Key

11. Explain the significance of NULL in mysql.

12. List and Explain the property of relation.

13. . What is the purpose of using MYSQL? Name the official site of mysql.

14. Explain any two key features of mysql.

15. What is SQL? Mention different categories of commands of sql. Give egs of each commands.

16. What do you understand by MySQL server?

17. What do you understand by MySQL client?

Client -> request ---> server -->responds to client

18. Answer in one word: (PAGE277)

a. collection of logical related records (TABLE)

b. DBMS creates a file that contains description about the data stored in the db. (Data
dictionary)

c. special value that is stored actual data values is unknown for an attribute (NULL)

d. attribute that can uniquely identify the tuple in a relation (PK)

e. an attribute which can uniquely identify tuples of table but not defined as PK of the table
(Alternate Key)
f. a group of attributes declared as PK (composite-PK)

19. Differentiate between DDL and DML.

20. Full of : DDL, DML, TCL, SQL, LAMP

21. Study the given below tables and answer the following questions

Table: USER

UID Password Security_question


Seema_12@gmail.com Seema My first school
raghav@gmail.com raghu My nick name
rahul@gmail.com rash Hope you know my name
Rahul_77@gmail.com London My home town

Table: Passenger

PNR P_name P_age Gender UID Train_ID Seat_no


10023 Seema 23 F Seema_12@gmail.com WB7890 B21
10024 Raghav 45 M raghav@gmail.com AMD234 B33
10025 Rahul 37 M Rahul_77@gmail.com PUN77 A55

Table: Train

Train_id T_name Train_type


WB7890 West Bengal express Non-A/c
PUN77 Pune Queen AC
AMD234 Ahmedabad Tej Express AC

Identify the PK in all tables. Give reason.

Does any table have any composite-primary key?

Identify the Foreign Key in table(s).

Identify the cols/attributes from all tables that can allow unique values. Justify your answer.

What is the degree and cardinality of all tables.

Name the passenger who is registered but not booked any train?

You might also like