Chapter $8,$ textbook page $377,$ "Review Questions, #$8-8"$

$(5$ points$)$

$8-8.$ What are the objectives of gelecting a data type for a field?

NOTE from Beckman: to answer questions from chapters $5$ and $6,$ you $\frac{?}{MU}S{T}_{?}$ look at the structure and contents

of the database you're working with $($shown on pages $245$ and $291$; they are identical$)$ so that you use

correct names for tables and attibutes and also use correct attribute values in search strings.

Remember that "literal" values such as text strings and dates must be enclosed with tick$-$marks $($i$.$e$.,$

single$-$quote marks$)$; numeric values of any data type $($integer or floating$-$point values$)$ are NOT

enclosed in tick$-$marks, such as StudentID, Eacultabld, and SectionNio.

Chapter $5,$ textbook page $245,$ "Problems and Exercises, #$5-39.$a and #$5\mathrm{.}39\mathrm{.}6".$

$(5$ points$)$

$5-39.$ Write SQL queries for the following

a$.$ Create two different forms of the INSERT command to add a student with a student ID of $65798$

and last name Lopez to the Student table.

b$.$ Now write a command that will remove Lopez $($this same student from $5$a$)$ from the Student

table.

STUDENT $($StudentID$,$ StudentWame$)$

FACULTY $($Faculty$,$ FacultyNamo$)$

COURSE $($CoursolD$,$ CourseName$)$

QUALIFIED $($FacultylD$,$ CourselD, DateQualified$)$

SECTION $($SoctionNo$,$ Semostor, CourselD$)$

PEGISTPATION $($Studentio$,$ SectionNo$)$

Chapter $6,$ textbook page $291,$ "Problems and Exercises, #$6-26.$b$".$

$(5$ points$)$

$6-26.$ Write SQL retrieval commands for each of the following queries:

b$.$ Display the numbers and names of all courses for which Professor Berndt has been qualified.