Lectures 15 - Assignment 6 March 8 Lecture

Lectures 15 - Assignment 6 March 8 Lecture - Assignment 6...

Info iconThis preview shows pages 1–11. Sign up to view the full content.

View Full Document Right Arrow Icon
Click to edit Master subtitle style 3/17/10 Assignment 6 Lectures
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
3/17/10 The Course So Far In this course, we have looked at two similar ways to organize information: Relational Databases in Third Normal Form Visual Basic programs using object- oriented methods. In the last two assignments, we have explored ways for these two forms of organization to work together, by
Background image of page 2
3/17/10 Database Design In assignment 1, you designed relational databases. Since databases are critical to the operation of modern businesses and other organization, Designing those databases properly is very important. Relational databases are the most widely-used databases in operation.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
3/17/10 Database Design Principles Relational databases are designed to prevent errors due to the three anomalies: INSERT anomaly UPDATE anomaly DELETE anomaly This results in databases which are designed for optimal storage, not
Background image of page 4
3/17/10 Third Normal Form Each table in a database should have a primary key. No cell in a table should contain multiple data items. One-to-many and Many-to-many relationships should not be contained in a single table. The Golden Rule for 3NF: All non-key fields should depend on the key, the
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
3/17/10 OOP In assignment 2, you became familiar with one of the core concepts in OOP —the Class. You also learned how to use some of the basic VB controls How to write code to extract properties from ListBox selections, and How to use “&” to build String data
Background image of page 6
3/17/10 OOP In assignment 3, you learned about some of the main reasons that OOP is popular: It allows complicated code to be encapsulated into Classes, which means that it won’t have to be written again. It simplifies the reuse of code: You could create many different objects from each class.
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
3/17/10 Graphics In assignment 3, you also learned that VB lets you write code to do some pretty cool graphics and animation. This, of course, can be combined with everything else VB can do to produce programs that are both useful and visually interesting. It’s also a bit easier to understand
Background image of page 8
3/17/10 SQL For assignments 4 and 5, we learned a new language: SQL (Structured Query Language) SQL is the standard language used to communicate with relational databases. All major DBMS’s support it. Most DBMS’s come with client tools which provide a way to send SQL
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
3/17/10 SQL and VB VB provides some standard code for connecting VB programs to databases. This has been encapsulated for you
Background image of page 10
Image of page 11
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 54

Lectures 15 - Assignment 6 March 8 Lecture - Assignment 6...

This preview shows document pages 1 - 11. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online