STUDENT Name Student_number Class Smith 17 1 Brown 8 2 COURSE Course_name Intro to Computer Science Data Structures Discrete Mathematics Database SECTION Course_number CS1310 CS3320 MATH2410 CS3380 Section_identifier Course_number 85 MATH2410 92 CS1310 102 CS3320 112 MATH2410 119 CS1310 135 CS3380 Major CS CS Fall Fall Credit_hours 4 4 Spring Fall Fall Fall 3 3 Semester Year 8668888 07 07 08 08 08 08 Department CS CS MATH CS Instructor King Anderson Knuth Chang Anderson Stone Figure 1.2 A database that stores student and course information. GRADE REPORT Student number 17 17 8 8 8 8 PREREQUISITE Course_number CS3380 CS3380 CS3320 Section_identifier 112 119 85 92 102 135 Prerequisite_number CS3320 MATH2410 CS1310 Grade B A A B A

STUDENT Name Student_number Class Smith 17 1 Brown 8 2 COURSE Course_name Intro to Computer Science Data Structures Discrete Mathematics Database SECTION Course_number CS1310 CS3320 MATH2410 CS3380 Section_identifier Course_number 85 MATH2410 92 CS1310 102 CS3320 112 MATH2410 119 CS1310 135 CS3380 Major CS CS Fall Fall Credit_hours 4 4 Spring Fall Fall Fall 3 3 Semester Year 8668888 07 07 08 08 08 08 Department CS CS MATH CS Instructor King Anderson Knuth Chang Anderson Stone Figure 1.2 A database that stores student and course information. GRADE REPORT Student number 17 17 8 8 8 8 PREREQUISITE Course_number CS3380 CS3380 CS3320 Section_identifier 112 119 85 92 102 135 Prerequisite_number CS3320 MATH2410 CS1310 Grade B A A B A

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Give at least three reasons why restrictions should always be imposed by the database rather than the application.
When dealing with missing field values in a database, what are the three actions to take?
PLZ help with the following: A nonprofit Canadian organization that provides aid to people after natural disasters needs your help to manage their data and to design a database for them using the following business rules: Individuals volunteer their time to carry out the tasks of the organization. Each volunteer may be assigned to several tasks during the time that they are doing volunteer work, and some tasks require many volunteers. It is possible for a volunteer to be in the system without having been assigned a task yet. It is possible to have tasks that no one has been assigned. When a volunteer is assigned to a task, the system should track the start time and end time of that assignment. The tasks of type “packing” result in the creation of packages. Each individual package of supplies that is produced by the organization is tracked. Each package is assigned an ID number. The date the package was created, and total weight of the package is recorded. A given package is associated…
Write SQL update statements to do the following on the database schema shown in Figure 1.i. Insert a new course, <‘Knowledge Engineering’, ‘CS4390’, 3, ‘CS’>.ii. Delete the record for the student whose name is ‘Smith’ and whose student number is 17.
What distinguishes the two kinds of integrity constraints?
In what circumstances would utilizing default values promote data integrity, and in what circumstances will doing so reduce it?
What are the main characteristics of functional dependencies that are used for normalization?
The foreign key's role in ensuring a database's consistency is what? Do you have a specific goal in mind?
Implement your table design by creating table statements. Your tables should have constraints such as primary keys and foreign keys. (You can use MySQL Workbench or any other database management system of your choosing). Types such as Char, Integer must be correctly placed. 2) Add one trigger to your database that utilizes a default function of your DBMS 3) Add dummy data to your database. (5 manual entries for each table should be sufficient.) 4) Consider the nominal forms and integrity of your database, it will affect your grade. Export your database from your DBMS, zip it and submit the zip file. Thank you!