- What is the difference between SQL and MySQL?
- What do you mean by DBMS? What are its different types?
- What are the types of joins in SQL? Give an example for each one.
- What is a Primary key?
- What are the different operators available in SQL?
- What is the need for group functions in SQL?
- What is a Relationship and what are they?
Please discuss these questions with your partners and post your answers as a comment on this gist when you are finished.
Team Members: Muna Al Haj Eid, Mohammed El amarieh, Mohammed Karbejha, Hadeel obeid, Omar Masud.
MySQL is a relational database management system that uses SQL as its standard language for managing data.
1- DBMS stands for Database Management System. It's like a digital filing cabinet that keeps your data organized and easily accessible. There are different types like relational (tables & rows), NoSQL (flexible for unstructured data), and object-oriented (data & functions combined).
Choosing the right one depends on your data needs and complexity.
Primary Key: A primary key is a unique identifier for a record in a database table. It ensures each row in the table is uniquely identifiable and helps in establishing relationships between different tables in a database.
SQL Operators: Different operators available in SQL include:
One-to-One: One row in one table relates to one row in another (e.g., customer to email).
One-to-Many: One row in one table relates to many rows in another (e.g., customer to orders).
Many-to-Many: Many rows in both tables can relate to each other (e.g., actors to movies).