cyhsutw

[{"captionFontSize":40,"captionTextAlignment":1,"caption":"PLAID","captionFrame":"{{-0.55944055, 191.32867}, {320, 95.104897}}","captionFontName":"AvenirNext-UltraLight","captionColorCombination":"{0, 1}","imageFrame":"","layoutType":0,"imageURL":""},{"captionFontSize":16,"captionTextAlignment":0,"caption":"Tibique facilisi ad qui. Nihil posidonium per at, no option atomorum cum. Qui te dicunt aperiam, pri dicunt legimus consulatu ad, fastidii omittantur ius ei. Nisl honestatis est id, vim ne tale antiopam postulant.","captionFrame":"{{0, 323.91608}, {320, 156.08391}}","captionFontName":"HelveticaNeue-Light","captionColorCombination":"{3, 1}","imageFrame":"{{0, 0}, {320, 480}}","layoutType":1,"imageURL":"http:\/\/s3.amazonaws.com\/Charmy_outfits\/outfits\/outfit_18.jpg"},{"captionFontSize":16,"captionTextAlignment":0,"caption":"Tibique facilisi ad qui. Nihil posidonium per at, no option atomorum cum. Qui te dicunt aperiam, pri dicunt legimus consulatu ad, fastidii omittantur ius ei. Nisl honestatis est id, vi

cyhsutw

{
    aps =     {
        alert =         {
            "loc-key" = "OUTFIT_UPLOADED";
        };
    };
    badge = 1;
    "content-available" = 1;
    imageURL = 2314;
    outfitId = 33;

cyhsutw

{
  templateName:"Overloaded",
  image:{
    frame:"{x:0, y:1, width:10, height:20}"
  },
  text:{
    frame:"{x:0, y:1, width:10, height:20}",
    autoResize:1,
    textAlignment:"NSTextAlignment",
    maxLength:20,

cyhsutw

template-1.bundle/
    template.plist
    resources/
        font.ttf
        font.otf
        background.png
    

cyhsutw

Assignment-2

This document is written in GitHub flavoured markdown syntax. You may view this document here.

---

1. Selected C syntax subset
   • variable declaration/variable initialization

cyhsutw

README

This document is written in GitHub flavoured markdown syntax. You may view this document here.

---

To run this program, please execute the following commands.

cyhsutw

CREATE TABLE hospital (
	id				BIGSERIAL PRIMARY KEY,
	name			VARCHAR(200),
	city			VARCHAR(200),
	country	 VARCHAR(200)
);

CREATE TABLE birth (
	id 			BIGSERIAL PRIMARY KEY,
	given_name 	VARCHAR(200),

cyhsutw

DROP TABLE birth_record CASCADE;
DROP TABLE classmate CASCADE;
DROP TABLE criminal_record CASCADE;
DROP TABLE death_certificate CASCADE;
DROP TABLE hospital CASCADE;
DROP TABLE victim CASCADE;
DROP TABLE driver_license CASCADE;
DROP TABLE incident CASCADE;
DROP TABLE witness CASCADE;

cyhsutw

CREATE VIEW birth_record AS
  SELECT p.id AS person_id,
         p.given_name AS given_name,
         p.birthday AS date_of_birth,
         h.country AS country_of_birth,
         m.given_name AS mother_name
  FROM birth p, hospital h, birth m
  WHERE p.mother_id = m.id AND p.hospital_id = h.id ORDER BY p.id ASC;

CREATE VIEW death_certificate AS

cyhsutw

BEGIN;
INSERT INTO hospital (id,name,city,country)
VALUES(1,'A_hospital','Taipei','Taiwan');
INSERT INTO hospital (id,name,city,country)
VALUES(2,'B_hospital','Taipei','Taiwan');
INSERT INTO hospital (id,name,city,country)
VALUES(3,'D_hospital','Tainan','Taiwan');
INSERT INTO hospital (id,name,city,country)
VALUES(4,'C_hospital','Tainan','Taiwan');
INSERT INTO hospital (id,name,city,country)