Answer any seven out of ten. દશમ ાથી કોઇપણ સ તન જવ બ આપો. 1. Describe foreign key. ૧. foreign key વણણવો. 2. Define super key. ૨. Super key ની વય ખય આપો. 3. What is Data Dictionary? ૩. Data Dictionary શ ાછ? 4. What is Metadata? ૪. Metadata શ ાછ? 5. Define instance. ૫. Instance ની વય ખય આપો. 6. Explain weak entity set. ૬. weak entity set સમજાવો. 7. Define primary key. ૭. primary key ની વય ખય આપો. 8. Define REFERENCE KEY. 9. Explain strong entity. ૯. Strong entity સમજાવો. 10. Define Schema. ૧૦. Schema ની વય ખય આપો.
Explain second Normal Form (2NF) with example. (ડ) Second Normal Form (2NF) ઉદ હરણ સ થ સમજાવો.
[4 marks]Explain aggregation in E-Rdiagram પરશન. ર (અ) E-Rdiagram મ aggregation સમજાવો
[3 marks]Explain the distributed database architecture. (અ) Distributed database architecture સમજાવો
[3 marks]Explain concepts of data abstraction. (બ) data abstraction નો concepts સમજાવો.
[3 marks]Explain Data independence. (બ) Data independence સમજાવો.
[3 marks]Explain the three level architecture of DBMS. 1/3 (ક) DBMS ન ાthree level architecture સમજાવો.
[4 marks]Explain relational model of DBMS. (ડ) DBMSન relational model સમજાવો.
[4 marks]Write a short note on SQL VIEW. (ક) SQL VIEW પર ટક ા નોધ લખો.
[4 marks]Explain the DML command in SQL. (ક) SQL મ ાDML command ન સમજાવો.
[4 marks]What is single row function in SQL? (ડ) SQL મ ાsingle row function શ ાછ?
[4 marks]What is the role of a DBA? પરશન. 3 (અ) DBA નો રોલ શ છ?
[3 marks]Explain attributes of entity with example. (અ) Entity ન ા attributes ઉદ હરણ સ થ સમજાવો.
[3 marks]Explain normalization. (બ) Normalization સમજાવો.
[3 marks]Explain specialization in E-Rdiagram.
[3 marks]Explain the DDL command in SQL. (ક) SQL મ ાDDL command ન સમજાવો.
[4 marks]Explain the application of DBMS. (ડ) DBMSની application સમજાવો
Explain generalization. (બ) Generalization સમજાવો.
[4 marks]Explain create and alter commands with example. (બ) Create અન alter આદશો ઉદ હરણ સ થ સમજાવો.
[4 marks]What is mapping cardinality? પરશન. ૪ (અ) Mapping cardinality શ છ?
[3 marks]Explain delete anomalies. (અ) Delete anomalies સમજાવો.
[3 marks]What is a join? Explain different types of joins. (ક) Join શ ા છ? Joins ન ા વવવવધ પરક રો સમજાવો
[7 marks]Explain the GRANT and REVOKE statement in SQL. પરશન. ૫ (અ) SQL મ ાGRANT અન REVOKE statement સમજાવો
[4 marks]Explain the character function in SQL. (બ) SQL મ ાCharacter function સમજાવો. 2/3
[4 marks]Explain Functional dependency. (ક) Functional dependency સમજાવો.
[3 marks]Explain Boyce Codd Normal form (BCNF). 3/3
[3 marks]