INFOSYSTEMS

Discuss your preference between the Microsoft and Google design principles. Which do you prefer and why? How have their design principles changed since you started using the internet?

DATA MANAGEMENT FOR INFOTECH

Based on triggers and stored procedures.

Consider your life as a relational database and define 5 triggers and 5 stored procedures that would be useful in your life. Write pseudo-code for such triggers and/or stored procedures. For example:

CREATE OR REPLACE TRIGGER brush_my_teeth

BEFORE UPDATE OR INSERT ON sleep_tracker

FOR EACH ROW

BEGIN

IF :NEW.datetime_went_to_bed IS NOT null

AND :NEW.did_brush_teeth IS FALSE THEN

RAISE_APPLICATION_ERROR(-20010,’I must brush my teeth before going to bed’);

END IF;

END;

AGILE METHODOLOGY

Part of “learning quickly” requires getting early versions of your product into the hands of customers as soon as possible. But ‘early versions’ have downsides. Why is it important to focus on “early adopters” for alpha tests?