What do you mean by Database? What kind of Role is Played by the Database in an organization? Please state your views
[7 marks]“Data is processed into Valuable Information and Valuable Information is processed into Knowledge” - Justify the Statement
[7 marks]Explain any Four Components of Database with Examples
[7 marks]Write the note on: Data Architecture
[7 marks]Write the note on: Data Independence
[7 marks]What are the Integrity Constraints and Pitfalls in RDBMS?
[7 marks]From the Given Data, Create 5 Different Queries and Sub Queries: Roll No First Name Last Name Subject 2001 Akshay Sharma Chemistry 2002 Adam Gilchrist Biology 2003 Brad Pitt Chemistry 2004 Clinthia Kardashian Physics 2005 Daniel Mirza Physics
[7 marks]What is SQL? State Various Features of SQL?
[7 marks]From the Following Data, Create 5 Different Queries and Sub Queries: Id First Last City State Phone Name Name 75231 Anita Gediya Hyderabad Telangana (040) 23232521 75232 Joseph D’ souza Panji Goa (0832) 5641120 75233 Khushbu Jethva Bhavnagar Gujarat (0278) 3662541 75234 Mitali Patel Pune Maharashtra (020) 65451120 75235 Dev Dixit Indore M.P. (0731) 3225645
[7 marks]What is RDBMS? What is the Structure of Relational Data?
[7 marks]Explain with Diagrams (Any two): 1) Physical Data Model 2) Conceptual Data Model 3) Logical Data Model1
[7 marks]Write a Note on: Database Relationships. Also Explain all Models with Charts and Diagrams of 3 Students
[7 marks]Write a Short Note on: Single Row Functions of Structured Query Language
[7 marks]What is Normalization? Explain any 2 Forms of your choice with suitable example
[5 marks]Write a Brief Note on: Multiple Row Functions of Structured Query Language
[5 marks]