Archive

Archive for the ‘Databases’ Category

BITS week 8 and 9

November 18th, 2013 No comments

Lecture slides on Cartesian Product and Join – database 3 2011 handouts

Lab exercise on CP and Join – SQL Session 3

 

More advanced Joins –database 3 join extra 2007 3 slides handouts

Lab exercises on more advanced Joins –SQL SESSION OUTER

 

Lecture slides on writing queries for dummies – database 4 2007 handouts

Lab exercises on DDL/DML – SQL Session 4

Categories: BIS, BIT, Databases Tags:

BITS week 7

November 11th, 2013 No comments

Material for BITS week 7

Slides on  TCP/IP

Slides on selection in RA and SQL database 2 2007 handouts 3 slides

Lab notes and exercises SQL Session 2

Categories: BIT, Databases Tags:

BITS week 6

November 4th, 2013 No comments

This weeks materials are an introduction to database systems and the relational model

The lecture slides used for the first session on databases relational database handout slides

SQL file required to set up the EMP database in mySQL empDB

SQL notes on using mySQL and the projection statement SQL Session 1

Notes on setting up your own version of MAMP (mac) Installing and using MAMP

Notes on setting up your own version of XAMPP (Windows 7) Installing and using XAMPP

Categories: BIT, Databases Tags: ,

Relational Databases – Functions, Grouping and sub-queries

February 20th, 2012 No comments

Lecture materials on Functions, Grouping and sub-queries database 5 2011 handouts

Lab material on Functions, Grouping and sub-queries SQL Session 5

Categories: BIT, Databases Tags:

Relational Databases – other operations and DDL

February 9th, 2012 No comments

Slides for this sesssion database 4 2011 handouts

Lab exercise on the DDL and DML SQL Session 4

Slides on different type of Join Slides on Outer, Left, Right Join

Lab Notes on the Outer Join SQL SESSION OUTER

Categories: BIT, Databases Tags:

Relational Databases – SQL and selection

February 2nd, 2012 No comments

Materials for the second part of Databases – keys, ordering and selection in RA and SQL

Lecture slides database 2

SQL notes on ordering and selection SQL Session 2

Categories: BIT, Databases Tags:

BBM 007 Assessment

February 21st, 2011 No comments

Full details of the assessment can be seen in Assignment (PDF)

Hints and tips about structuring the report can be seen in this post/document

This work should be done in pairs and submitted as a single word document, with all code, diagrams and data examples included in the document.

The hand-in date/time is 2nd May 2011 at 6:00pm. Electronic submission (only) is required – either through the digital drop box  or using the email address barryavery65@gmail.com

You submit one document per group. If you submit by email I will email you back so you know its arrived (probably the next day in the morning).

Categories: BIS, Databases Tags:

Database Design Methodology

February 17th, 2011 No comments

Here are the slides on Database Design Methodology which are very heavily based on the Chapters from the Database book by Connolly & Begg.

This is really only a summary – you need to read the chapters on Conceptual, Logical and Physical design in the book.

Database Design slides

Categories: Databases Tags:

SQL statements to create EMP DEPT and GRADE tables

February 14th, 2011 No comments

This zipped text file contains three SQL blocks which should create and populate the EMP, DEPT and GRADE tables in SQL compliant databases

It contains three blocks that look like this

// create table SQL
create table emp (
empno int,
… etc.
);
// Lines to insert tuples into the table created above
insert into emp values (405,”MARCH”,”ADMIN”,938,”13/06/1997″,18000,null,2);
insert into emp values (535,”BYRNE”,”SALES”,734,”15/08/1997″,26000,300,3);
etc..

Categories: Databases Tags:

ITB week 10

December 7th, 2010 No comments

This session covers Open Source and Free Software and talks about the similarities and differences between them. Notes are here

The second part finishes the database material and covers problem with the relational model, functions, grouping and subqueries, notes are here

Additional notes about the assignment are here – all the other material about the assignment are here

For those that missed the discussion or the link last week, information about the second test is here