Department of Computer Science
The College at Brockport
Using phpMyAdmin on csdb from off campus.
Tim Mullins/Sandeep Mitra
This requires port forwarding. It is a good idea to forward ports 80, 443 and 3306.
From on campus to access phpMyAdmin all you nee
Department of Computer Science
The College at Brockport, State University of New York
CSC/CIS 422: Relational Database Systems
Group Project 1: Database Design (40 points)
Date Due: March 3, 2014
Problem Description
Brockports Fast TRAX Bicycle Rental pro
Employee
(Employee) Banner ID (int) <FK>
Credentials ( VARCHAR (20)
Password ( VARCHAR (15)
Michael Leib, Nick Seitzinger, Brian Albanese, John Cassese
Customer
(Customer) Banner ID (int) <FK>
User Type (VARCHAR(15)
Blocked (Boolean)
Demographics
Banner I
Department of Computer Science
The College at Brockport, State University of New York
CSC/CIS 422: Relational Database Systems
Individual Homework 2: Database Queries (100 points)
Due Date: 04/07/2014 Brian Albanese
Problem Description
Given the database
Department of Computer Science
The College at Brockport, State University of New York
CSC/CIS 422: Relational Database Systems
Individual Homework 1: Database Design (50 points)
Date Due: February 19, 2014
Problem Description
The Department of Computer Sc
- phpMyAdmin SQL Dump
- version 3.5.8.2
- http:/www.phpmyadmin.net
-
- Host: localhost
- Generation Time: Mar 16, 2014 at 12:02 AM
- Server version: 5.1.73
- PHP Version: 5.3.3
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @
Department of Computer Science
The College at Brockport
Instructions on using the phpMyAdmin tool to manage mySQL databases on the
csdb server
Sandeep Mitra
1. You can access the phpMyAdmin tool online (if you are working from offcampus, then for security
CSC/CIS 422: Relational Database Systems
Basics of the Java Database Connectivity (JDBC) package
Sandeep Mitra/T M Rao
What is JDBC?
So far, you have been using a Database Management System (DBMS) directly to talk to
the database entities (tables, etc.) y
Structured Query Language (SQL)
T.M. Rao
Notes-03-sql
SQL: Structured Query Language
Not a general-purpose language like Java or C+
Developed at IBM in the 1970s
ANSI Standard in 1992 (SQL-92)
All DBMSs process SQL. Even if you do things using the GUI
Department of Computer Science
The College at Brockport, State University of New York
CSC/CIS 422: Relational Database Systems
Individual Homework 2: Database Queries (100 points)
Due Date: 04/07/2014 Brian Albanese
Problem Description
Given the database
