VKEDCO: Vladimir Kulyukin's Education Coop: MobAppDev: Assign ...

1. Start with Object-Oriented modeling and implement the Mathematician class that models the mathematician table.

2. Design and implement database adapter, MathDbAdptr, and database populator, MathDbPopulator, classes. The database adapter will be responsible for creating, populating, quering, and maintaining the database. The database populator is responsible from creating Mathematician objects from XML.

3. Use the following SQLite script to associate an insertion trigger with the mathematician table. Follow the steps outlined in Lecture 16 on how to do this.

-- sqlite script for timestamping mathematician insertions
CREATE TABLE IF NOT EXISTS mathematician (id INTEGER PRIMARY KEY AUTOINCREMENT,
??? ??? ??? ? FirstName TEXT not null,
??? ??? ??? ? LastName? TEXT not null,
??? ??? ??? ? BirthYear INTEGER not null,
??? ??? ??? ? DeathYear INTEGER not null,
??? ??? ??? ? ResearchArea TEXT not null,
??? ??? ??? ? WikiURL TEXT not null,
??? ??? ??? ? Picture BLOB not null,
??? ??? ??? ? TimeStamp DATE);

CREATE TRIGGER insert_math_time_stamp AFTER INSERT ON mathematician
BEGIN

UPDATE mathematician SET TimeStamp = DATETIME('NOW')
??? WHERE rowid = new.rowid;
END;

4. Make sure that you carefullly define all constants for column names and numbers when you develop the adapter. You may want to review the development tips in Assignment 08 before designing and implementing the adapter class. The SQLiteImageBlopApp that we discussed in Lecture 16 has examples of adapter and populator classes.

5. When you develop your apps, set the minimum SDK to Android 2.2 and the target SDK to Android 2.3.3.
?

Create hw_09 subfolder in your Dropbox folder and place your? zip/rar Eclipse project in there.

Source: http://vkedco.blogspot.com/2012/10/mobappdev-assign-09.html

Dexter Season 7 Ryder Cup 2012 Johnny Lewis pnc Honey Boo Boo yom kippur yom kippur