DBMS 110 - S09 Lab Assignment Chapter 7 RQ 7.3 to 7.40
The Review Questions 7.3 to 7.40, from the Kroenke book starting page 357, have been duplicated below, to
assist in the completion of this Lab Assignment.
RQ Questions 7.1, 7.2 and 7.3 are answ
S06 Chapter 5 Conger Book Practices Assignment
NAME _Heather Brown_
The questions below are from the Conger Book Practices Assignment on page 100. Use this Assignment form to enter
your answer below each question.
Before completing this assignment please
What kind of relationship does this crows feet symbol represent?
@ One to one
0 One to many
0 Many to many
0 None of these
Which ofthe following best denes a trigger?
@ Executable scn'pts of SQL Cede that is triggered by an event
Ch. 6: Transforming Data Models into DB Design
Appendix B: Getting Started with Systems Analysis and Design
PURPOSE OF DB DESIGN
Database design: Set of db specs that can actually be implemented as a db in a DBMS.
CREATE A TABLE FOR EA
Ch. 7 SQL for DB Construction & Application Processing
5 categories of SQL statements
Data definition language (DDL): used for creating tables, relationships, & other DB structures
Data manipulation language (DML): used for querying,
Session 10 Quiz
Question 1 The SQL SET keyword is used to specify a new value when changing a column value.
Question 2 If the table ITEM has a column WEIGHT, and WEIGHT has the data type Numeric (4,2), the value 4321 will be
S06 ERD and Normalization - Conger
Logical design ignores any reference to the DBMS that will be used.
ERD a diagram of entities, their attributes, and the relations among the
Entities represented by rectangles:
S 1 0 U s i n g S Q L Vi e w s
SQL View is a virtual table.
It contains no data but gets data from other tables.
Data recorded facts and figures
Knowledge derived from data
Data presented in a meaningful context
Data processed by summing,
Ch. 6 Physical Design Conger book
Choosing a DBMS
Important factors to consider
o Compatibility with your network and operating systems
o Hardware and software requirements for the DMBS
o Features of the DBMS in relation to your DB req
Ch. 7 SQL Conger book
SQL: Programming language used to manipulate data and data objects in a relational DB.
o ANSI standard
o ISO standard
Most RDBMSs comply to the standards to a fairly high degree, which means the SQL you writ
S11 Database Redesign
/* * SQL-Query-CH08-01 * */
SELECT A.FirstName, A.lastName
FROM ARTIST AS A
WHERE A.ArtistID IN
FROM WORK AS W
WHERE W.Title = 'Blue
/* * SQL-Query-CH08-02 * */