CSE103 exam

(Answer is in bold)

• The definition of Information System

• foreign key constraint

• odbc (c refers to connectivity)

• dbms is interface between database and program (From the book "The design of DBMS must take into account the interface between the DBMS and operating system")

• IBM's IMS uses hierarchical DBMS

• referential integrity rule applies to foreign keys

• QBE(query by example)

• Count(*)

• grouped query (GROUP BY)

• restricting groupings (HAVING clause)

• nested query

• BCNF: if and only if, every determinant is a candiate key

• create schema, domain, table, view (DDL)

• grant (revoke cascade|restrict )

• UML(multiplicity of relation)

• Armstrong’s axiom

  

• update anomaly

• UK’s 1998 Data Protection Act (people cannot erase the data)

• data types

• create database is normalised

• In MS access, input mask is used for data entry

• normalisation is a data validation technique

• UML notation, like natural join, selection, projection, etc.

• first develop DB model then process normalization (ch 17.2)

• (jdbc) executeQuery, what does rs.next() do? Moves the cursor froward one row from its current position

// answer source: http://docs.oracle.com/javase/6/docs/api/java/sql/ResultSet.html#next%28%29
ResultSet rs = stmt.executeQuery();

rs. next()

Disclaimer: This post is copied from there