DROP TABLE COUNTRY CASCADE CONSTRAINTS;
CREATE TABLE COUNTRY (
cntry_cd
cname
ename
curr_cd
upd_dt
upd_uid
);
CHAR(3) NOT NULL,
VARCHAR2(32) NOT NULL,
VARCHAR2(32) NOT NULL,
CHAR(3) NOT NULL,
DATE DEFAULT SYSDATE NOT NULL ,
VARCHAR2(16) NOT NULL
DROP TABL
1. Relational Algebra [50%]
Consider the following database.
Person(name, age, gender)
Frequents(name, pizzeria)
Eats(name, pizza)
Serves(pizzeria, pizza, price)
Person
Serves
Eats
name
age
gender
pizzeria
name
pizza
pizza
price
Chicago
Pizza
cheese
7.75
CS3402 Database Systems:
File Organization and Indexing
CS3402
1
Overview
Disk Storage Devices
Files of Records
Operations on Files
Unordered Files & ordered Files
Types of Single-level Indexes
Primary Indexes
Clustering Indexes
Secondary Indexes
Multi
CS3402
Database Systems
Topic 2: Introduction to SQL
Introduction to SQL
Supported by all major
commercial database systems
Standardized
Interactive via GUI or prompt
or embedded in programs
Declarative
Based on relational algebra
SQL
DDL: Create Table,
CS3402
Database Systems
Topic 3: JSON
Ref: http:/clarkdave.net/2013/06/what-can-you-do-with-postgresql-and-json/
JavaScript Object Notation (JSON)
Serializing data objects
Human-readable
Data Interchange
Representing and storing semistructured data
Basic
CS3402
Database Systems
Topic 1.1: Introduction
Ref:
https:/lagunita.stanford.edu/courses/Engineering/db/2014_1/
Motivation
Database management systems are used everywhere
Web applications
Scientific applications
Finance
Games
Transportation
Datasets
Spring 2017
CS3402 Tutorial No. 3
1. For the chosen application you have modeled using ER in the last week's tutorial
class, convert the ER diagram into relational schema (table structures) by following
the "rules" described in the lecture notes.
2. Consi
CS3402 Database Systems
Spring 2016
Sample Solutions for Homework
Question A.
(20 marks)
conduct
type
(Note: a more natural design would be to model Flight as a weak entity set which is dependent on Airline, in which case
its attribute Number would be a p
CS3402 Database Systems
Assignment 2 (due: 19/Apr. during the Lecture Class!)
Question A.
Consider the following proposed rule based on functional dependencies:
if (Movie -> Language) /\ (Distributor -> Language), then Movie -> Distributor.
Prove that the
:
:.
cs7 ?eL
:
Ansrver: Lnt tgrdbe a lwo-dimensional integer array
.
.
.
b.
.
. i-.
:";,!.ir;*$:t':rodd;.*r;
F
I
rr.cfw_,
ol, swe
n x m.
The physical lsvcl would simply be rc xn (probably consecutive) storage locations
whatever size is specified by the im
CS3402
Database Systems
Assignment
CS3402 Database Systems 16/17 SemB
Assignment02 SQL & Database Normalization
Question A Relational Algebra (24%)
A social network web application has organized their data using the relation schema below.
User (uid, uname
CS3402
Database Systems
CS3402 Tutorial 2:
1. Translate the ER diagram below to relational tables in the following steps.
(a) Map strong entity type into relation
(b) Map weak entity + identifying relationship type into relation
(c) Map binary 1:1 relatio
Exercise 2: Procedure for Demonstration of ODBC driver and Data Field Editing using JSP
and Access 2007
You can download this document and all material of this exercise in the following link:
http:/courses.cs.cityu.edu.hk/cs3462/exercise/ex5/index.html
Do
