{"id":163,"date":"2017-04-21T19:15:08","date_gmt":"2017-04-21T19:15:08","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/suny-the-missing-link-an-introduction-to-web-development-and-programming\/chapter\/section-4-assessments\/"},"modified":"2017-04-27T18:52:43","modified_gmt":"2017-04-27T18:52:43","slug":"section-4-assessments","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/suny-the-missing-link-an-introduction-to-web-development-and-programming\/chapter\/section-4-assessments\/","title":{"raw":"Section 4 Assessments","rendered":"Section 4 Assessments"},"content":{"raw":"For these assignments, use mysqldump() to submit a database export file or submit written work as a single document file.\r\n

Database Design<\/h1>\r\nCome up with a small database you would like to develop. Compile a list of fields and follow the process of normalization to create a data model with at least 5 tables that includes primary and foreign keys, and at least one table that is a many-to-many relationship.\r\n\r\nCreate a document that depicts your table structure and fields, identifies primary and foreign keys, and the connections between your tables.\r\n

Database Development<\/h1>\r\nUsing your database design from above, create the database using your system\u2019s command prompt. Create a text file that includes all of the commands you used to create your database as well as inserts for 3 full records in each table. Submit this file and a mysqldump of your actual completed database.\r\n

Database Interaction<\/h1>\r\nCreate queries that will interact with your database to complete the following:\r\n
    \r\n \t
  1. Display one of your tables without including foreign keys<\/li>\r\n \t
  2. Joins two (or more) of your tables to show a complete record<\/li>\r\n \t
  3. Generates information about your records that is not stored in your database<\/li>\r\n \t
  4. Updates record(s) in a table to a new value<\/li>\r\n<\/ol>\r\nSubmit your queries and the mysqldump file for your database.\r\n

    Discussion \/ Written Response<\/h1>\r\n
      \r\n \t
    1. Describe the three types of relationships between data and how to satisfy them in relational databases.<\/li>\r\n \t
    2. Describe the first three forms of normalization.<\/li>\r\n \t
    3. Describe the differences between flat file and structured query databases.<\/li>\r\n \t
    4. Describe the differences between SQL and NoSQL databases.<\/li>\r\n \t
    5. Describe when the different database types we examined are most useful.<\/li>\r\n<\/ol>\r\n

      Questions<\/h1>\r\n
      \r\n

      Take this quiz online!<\/a><\/h1>\r\n<\/div>\r\n
        \r\n \t
      1. What does SQL stand for?\r\n
          \r\n \t
        1. Standard Query Linguistics<\/li>\r\n \t
        2. Structured Query Language<\/li>\r\n \t
        3. Strict Query Language<\/li>\r\n \t
        4. None of the above<\/li>\r\n<\/ol>\r\n<\/li>\r\n \t
        5. Which of these is used to retrieve information from a database?\r\n
            \r\n \t
          1. Get<\/li>\r\n \t
          2. Fetch<\/li>\r\n \t
          3. Select<\/li>\r\n \t
          4. Find<\/li>\r\n<\/ol>\r\n<\/li>\r\n \t
          5. Which of these commands would get the name column from a Persons table?\r\n
              \r\n \t
            1. Select name from Persons;<\/li>\r\n \t
            2. Get persons.name<\/li>\r\n \t
            3. Select persons.name<\/li>\r\n \t
            4. Get name from Persons<\/li>\r\n<\/ol>\r\n<\/li>\r\n \t
            5. Which of the following select records where the name fields starts with an A?\r\n
                \r\n \t
              1. Select * from Persons where name=\u2018a\u2019<\/li>\r\n \t
              2. Select * from Persons where name like \u201ca%\u201d<\/li>\r\n \t
              3. Select * from Persons where name like \u201c%a\u201d<\/li>\r\n \t
              4. None of these<\/li>\r\n<\/ol>\r\n<\/li>\r\n \t
              5. Which of the following is the keyword used to sort results?\r\n
                  \r\n \t
                1. Order By<\/li>\r\n \t
                2. Sort By<\/li>\r\n \t
                3. Filter By<\/li>\r\n \t
                4. Ascending<\/li>\r\n<\/ol>\r\n<\/li>\r\n \t
                5. Which of the following is used to find the number of records?\r\n
                    \r\n \t
                  1. Total()<\/li>\r\n \t
                  2. Count()<\/li>\r\n \t
                  3. Sum()<\/li>\r\n \t
                  4. None of these<\/li>\r\n<\/ol>\r\n<\/li>\r\n \t
                  5. Eliminating multiple identical columns from a table is which normalization?\r\n
                      \r\n \t
                    1. First<\/li>\r\n \t
                    2. Second<\/li>\r\n \t
                    3. Third<\/li>\r\n \t
                    4. Fourth<\/li>\r\n<\/ol>\r\n<\/li>\r\n \t
                    5. Eliminating repeated values from a table is which normalization?\r\n
                        \r\n \t
                      1. First<\/li>\r\n \t
                      2. Second<\/li>\r\n \t
                      3. Third<\/li>\r\n \t
                      4. Fourth<\/li>\r\n<\/ol>\r\n<\/li>\r\n \t
                      5. Ensuring no values are repeated in a database is which of the following?\r\n
                          \r\n \t
                        1. First<\/li>\r\n \t
                        2. Second<\/li>\r\n \t
                        3. Third<\/li>\r\n \t
                        4. Fourth<\/li>\r\n<\/ol>\r\n<\/li>\r\n \t
                        5. Ensuring all fields relate directly to the table they are in is which normalization?\r\n
                            \r\n \t
                          1. First<\/li>\r\n \t
                          2. Second<\/li>\r\n \t
                          3. Third<\/li>\r\n \t
                          4. Fourth<\/li>\r\n<\/ol>\r\n<\/li>\r\n \t
                          5. The CRUD actions are:\r\n
                              \r\n \t
                            1. Compose, Read, Update, Delete<\/li>\r\n \t
                            2. Create, Read, Update, Destroy<\/li>\r\n \t
                            3. Create, Read, Update, Delete<\/li>\r\n \t
                            4. Copy, Read, Update, Drop<\/li>\r\n<\/ol>\r\n<\/li>\r\n \t
                            5. Including all of the records in the first table of a join is done using:\r\n
                                \r\n \t
                              1. Join all<\/li>\r\n \t
                              2. Left join<\/li>\r\n \t
                              3. Right join<\/li>\r\n \t
                              4. None of these<\/li>\r\n<\/ol>\r\n<\/li>\r\n \t
                              5. Queries can be placed inside of other queries.\r\n
                                  \r\n \t
                                1. True<\/li>\r\n \t
                                2. False<\/li>\r\n<\/ol>\r\n<\/li>\r\n \t
                                3. Which of the following is used to remove a record from a table?\r\n
                                    \r\n \t
                                  1. Delete from<\/li>\r\n \t
                                  2. Drop from<\/li>\r\n \t
                                  3. Destroy<\/li>\r\n<\/ol>\r\n<\/li>\r\n \t
                                  4. MySQL requires which of the following to run?\r\n
                                      \r\n \t
                                    1. Windows<\/li>\r\n \t
                                    2. Linux<\/li>\r\n \t
                                    3. Apple<\/li>\r\n \t
                                    4. Any of these<\/li>\r\n<\/ol>\r\n<\/li>\r\n<\/ol>\r\n
                                      \r\n

                                      Check your answers<\/a><\/h1>\r\n<\/div>","rendered":"

                                      For these assignments, use mysqldump() to submit a database export file or submit written work as a single document file.<\/p>\n

                                      Database Design<\/h1>\n

                                      Come up with a small database you would like to develop. Compile a list of fields and follow the process of normalization to create a data model with at least 5 tables that includes primary and foreign keys, and at least one table that is a many-to-many relationship.<\/p>\n

                                      Create a document that depicts your table structure and fields, identifies primary and foreign keys, and the connections between your tables.<\/p>\n

                                      Database Development<\/h1>\n

                                      Using your database design from above, create the database using your system\u2019s command prompt. Create a text file that includes all of the commands you used to create your database as well as inserts for 3 full records in each table. Submit this file and a mysqldump of your actual completed database.<\/p>\n

                                      Database Interaction<\/h1>\n

                                      Create queries that will interact with your database to complete the following:<\/p>\n

                                        \n
                                      1. Display one of your tables without including foreign keys<\/li>\n
                                      2. Joins two (or more) of your tables to show a complete record<\/li>\n
                                      3. Generates information about your records that is not stored in your database<\/li>\n
                                      4. Updates record(s) in a table to a new value<\/li>\n<\/ol>\n

                                        Submit your queries and the mysqldump file for your database.<\/p>\n

                                        Discussion \/ Written Response<\/h1>\n
                                          \n
                                        1. Describe the three types of relationships between data and how to satisfy them in relational databases.<\/li>\n
                                        2. Describe the first three forms of normalization.<\/li>\n
                                        3. Describe the differences between flat file and structured query databases.<\/li>\n
                                        4. Describe the differences between SQL and NoSQL databases.<\/li>\n
                                        5. Describe when the different database types we examined are most useful.<\/li>\n<\/ol>\n

                                          Questions<\/h1>\n
                                          \n

                                          Take this quiz online!<\/a><\/h1>\n<\/div>\n
                                            \n
                                          1. What does SQL stand for?\n
                                              \n
                                            1. Standard Query Linguistics<\/li>\n
                                            2. Structured Query Language<\/li>\n
                                            3. Strict Query Language<\/li>\n
                                            4. None of the above<\/li>\n<\/ol>\n<\/li>\n
                                            5. Which of these is used to retrieve information from a database?\n
                                                \n
                                              1. Get<\/li>\n
                                              2. Fetch<\/li>\n
                                              3. Select<\/li>\n
                                              4. Find<\/li>\n<\/ol>\n<\/li>\n
                                              5. Which of these commands would get the name column from a Persons table?\n
                                                  \n
                                                1. Select name from Persons;<\/li>\n
                                                2. Get persons.name<\/li>\n
                                                3. Select persons.name<\/li>\n
                                                4. Get name from Persons<\/li>\n<\/ol>\n<\/li>\n
                                                5. Which of the following select records where the name fields starts with an A?\n
                                                    \n
                                                  1. Select * from Persons where name=\u2018a\u2019<\/li>\n
                                                  2. Select * from Persons where name like \u201ca%\u201d<\/li>\n
                                                  3. Select * from Persons where name like \u201c%a\u201d<\/li>\n
                                                  4. None of these<\/li>\n<\/ol>\n<\/li>\n
                                                  5. Which of the following is the keyword used to sort results?\n
                                                      \n
                                                    1. Order By<\/li>\n
                                                    2. Sort By<\/li>\n
                                                    3. Filter By<\/li>\n
                                                    4. Ascending<\/li>\n<\/ol>\n<\/li>\n
                                                    5. Which of the following is used to find the number of records?\n
                                                        \n
                                                      1. Total()<\/li>\n
                                                      2. Count()<\/li>\n
                                                      3. Sum()<\/li>\n
                                                      4. None of these<\/li>\n<\/ol>\n<\/li>\n
                                                      5. Eliminating multiple identical columns from a table is which normalization?\n
                                                          \n
                                                        1. First<\/li>\n
                                                        2. Second<\/li>\n
                                                        3. Third<\/li>\n
                                                        4. Fourth<\/li>\n<\/ol>\n<\/li>\n
                                                        5. Eliminating repeated values from a table is which normalization?\n
                                                            \n
                                                          1. First<\/li>\n
                                                          2. Second<\/li>\n
                                                          3. Third<\/li>\n
                                                          4. Fourth<\/li>\n<\/ol>\n<\/li>\n
                                                          5. Ensuring no values are repeated in a database is which of the following?\n
                                                              \n
                                                            1. First<\/li>\n
                                                            2. Second<\/li>\n
                                                            3. Third<\/li>\n
                                                            4. Fourth<\/li>\n<\/ol>\n<\/li>\n
                                                            5. Ensuring all fields relate directly to the table they are in is which normalization?\n
                                                                \n
                                                              1. First<\/li>\n
                                                              2. Second<\/li>\n
                                                              3. Third<\/li>\n
                                                              4. Fourth<\/li>\n<\/ol>\n<\/li>\n
                                                              5. The CRUD actions are:\n
                                                                  \n
                                                                1. Compose, Read, Update, Delete<\/li>\n
                                                                2. Create, Read, Update, Destroy<\/li>\n
                                                                3. Create, Read, Update, Delete<\/li>\n
                                                                4. Copy, Read, Update, Drop<\/li>\n<\/ol>\n<\/li>\n
                                                                5. Including all of the records in the first table of a join is done using:\n
                                                                    \n
                                                                  1. Join all<\/li>\n
                                                                  2. Left join<\/li>\n
                                                                  3. Right join<\/li>\n
                                                                  4. None of these<\/li>\n<\/ol>\n<\/li>\n
                                                                  5. Queries can be placed inside of other queries.\n
                                                                      \n
                                                                    1. True<\/li>\n
                                                                    2. False<\/li>\n<\/ol>\n<\/li>\n
                                                                    3. Which of the following is used to remove a record from a table?\n
                                                                        \n
                                                                      1. Delete from<\/li>\n
                                                                      2. Drop from<\/li>\n
                                                                      3. Destroy<\/li>\n<\/ol>\n<\/li>\n
                                                                      4. MySQL requires which of the following to run?\n
                                                                          \n
                                                                        1. Windows<\/li>\n
                                                                        2. Linux<\/li>\n
                                                                        3. Apple<\/li>\n
                                                                        4. Any of these<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n
                                                                          \n

                                                                          Check your answers<\/a><\/h1>\n<\/div>\n\n\t\t\t
                                                                          \n\t\t\t

                                                                          Candela Citations<\/h3>\n\t\t\t\t\t
                                                                          \n\t\t\t\t\t\t
                                                                          \n\t\t\t\t\t\t\t
                                                                          CC licensed content, Shared previously<\/div>