Problem # 3: Normal Form (4NF) Suppose we have the following Courses table with columns CourselD, Instructor, Book that stores the courses, the instructor teaching the course, and the recommended books for the course. The book(s) recommended for a course does not depend on the teacher teaching the course, just on the course. Here is an example of instantiation for this table: Courses: CourseID Instructor Book IT360 Crainiceanu Kroenke IT360 Crainiceanu Welling IT360 DeLooze Kroenke Welling Kroenke IT360 DeLooze S1440 Crainiceanu SI440 Crainiceanu Ramakrishna n SI440 Crainiceanu Stonebraker a) Give an example of a multivalued dependency in the Courses table. b) Is the Courses table in 4NF? If answer to yes, say why. If not, decompose the table such that the resulting tables are in 4th normal form. For each of the resulting tables, give the table name, column names, primary keys, and foreign keys.
SQL
SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.
Queries
A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.
Step by step
Solved in 2 steps