Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 6 - Modular_V2.0_SQL_Flipbook
P. 6

    INSIDE THE SERIES

                      The key features of the series have been designed to ensure better learning, assessment
                      and evaluation.

                                                       Learning Resources

                            Your Aim: This section                                             Tech Funda: This section
                           describes the objective of                                       provides a practical information
                                 the chapter.                                                    or tip to the students.

                                                                                                   Tech Funda
                                                                                                  The default user for MySQL is root and by default it
                                                                                                  has no password.

                                                             Glossary: This section
                                                             contains definition of
                                                              important IT terms.
                           Clickipedia: This section                                           Hands On:  This section
                             provides interesting                                            contains craft based activities
                                                               GLOSSARY
                               computer facts.                                                  for home assignment.
                                                                Aliases: Aliases are used to give a table or column, a temporary name.
                                                                 Database: A database is defined as an organised collection of data that can be visualised
                                                               as a container of information.
                                                                 Database Server: Database  servers  are  dedicated  computers  that  can  hold the  actual
                                                               databases.
                                                                                               Hands On
                                                                 Function: Function is a set of predefined commands that perform specific operation to
                                                               return a value to the program.
                                                                Index: An index is a structure that is used to improve the performance of database activity.
                                                                 JOIN: A JOIN clause is used to combine rows or two tables based on at least one between   Create a  Books table with  BookID,  Title,
                                                               them.
                                                                MySQL: MySQL is an open-source RDBMS software which is available free of cost.  Author, and  Price columns. Set  BookID as
                                                                RDBMS: RDBMS is a relational DBMS in which tables are linked to each other by fields.  the PRIMARY KEY.
                                                                Relational model: A relational model can be represented as a table of rows and columns.
                                                                 SQL: SQL is the standard  language  for managing relational databases and performing
                                                               various operations on the data in the tables.
                                                                Subquery: A subquery can be defined as a query within another query.
                                                                View: A view is a temporary table which is created on the basis of table.
                                                               60  Touchpad MODULAR (Version 1.0)
                         D.  Short answer type questions.
                            1.  What is a table?
                            2.  Define default constraint.
                            3.  Write the syntax of the DROP TABLE command.
                            4.  Write the syntax for adding a column to a table.
                           In The Lab: This is a lab
                            5.  What is the use of CHECK constraint?
                         E.   Long answer type questions.                                     Recap: This section provides
                            1.  Write the steps to install MySQL.
                          activity to develop practical
                            2.  What are the constraints used in MySQL?
                            3.  How can you delete tables from a database?                    a summary of the chapter for
                            4.  How can we change the data type of the column in a table?
                                    skills.
                            5.  Describe any five data types used in SQL.
                         F.  Application based question.  Experiential Learning                  quick recapitulation.
                            1.  Anaya has created a table in SQL. Now, she wants to add one more field in the table. But she forgets
                          the syntax for adding a field in a table. Help her in doing so.
                            2.  Viraj is working on a table in MySQL. He wants to restricts the value range that can be placed in a
                          column. Suggest a SQL constraint that can help him.
                                   In the lab  Subject Enrichment
                         1.  Create a table named ‘Employee’ with the following structure:
                            EmpID   Integer
                            FirstName    Char(30)
                            LastName   Char(30)
                            Salary    Integer
                         2.  Create another table and set table constraints as follows:
                            a.  2 fieldnames as primary keys
                            b.  All fields to have not null values
                         Teacher's Corner
                         1.  Help the students downloading and installing MySQL.
                         2.  Demonstrate the students to modify a table with examples.
                                            Introduction to  MySQL  21

| 1 2 3 4 5 6 7 8 9 10 11 |