Ex One-02 Basic DDL - Joins
Write a command to create a table named club_member.
CREATE TABLE club_member
email VARCHAR2(255) NOT NULL UNIQUE,
passwd VARCHAR2(16) NOT NULL
Answer the following questions.
1.) What business rules do the column attribut
Ex One-03 Normalization Denormalization
Task1. Consider the two-table structure for assigning students to classes. Is it in first normal form? How
do you know? Explain, justifying your answer. Be very specific. The deliverable for this task is a paragraph
0 out of 0 points
For this quiz or exam, you may use resources such as the textbook and web resources to
help you. However, you may not get help from another person, either in person or
I understand and agree to the
10 out of 10 points
consider the query shown below.
Can the HAVING clause precede the GROUP BY clause? If so, are the result sets the same?
Yes and yes. The Oracle documentation says, "If you specify both GROUP
BY and HAVING, t
1. Write and test a query to report what students are enrolled in which classes,
ordering by class. Then create a view based on the query and select the
data using the view. Document with screen shots.
2. Can the view you created for question #1