TDDD12 Database Technology

Labs and Project

To do the labs, please follow the following four steps:

1. Register to the labs

At the latest the 4th of april, you should have registered to a lab group. If you have problems with the registration, please contact you lab assistant or the course examiner.

2. Set up the lab environment

How to do it as well as some important tips can be found here.

3. Do the labs and project

The labs are based on an existing database and, thus, it is important you familiarize with it. Please, check the following items:

• ER diagram for the Jonson Brothers database
• Data in the Jonson brothers database

The labs and project descriptions and requirements can be found here:

• Lab 1 and 2
• Lab 3 and project

A document with simplified MySQL syntax can be found here

The labs are done in MySQL, with the exception of labs 3 and 4a that are done on paper. Lektion 1 will prepare you for lab 3. In lektion 2, your lab assistant will give you feedback about your project ER diagram (check the timetable, please, for dates).

Please, note that during the project implementation (lab 4) your lab assistent will not be at the computer rooms at all times. You can always e-mail him/her if you need his/her help. You will be helped via e-mail or in person, if possible.

4. Handing in the labs and project

Deadlines:

• Lab 1: 2012-04-11 (SQL queries and views)
• Lab 2: 2013-04-18 (Database design and ER modeling)
• Lab 3: 2013-04-25 (Normalization)
• Lab 4a: 2013-04-29 (Design and ER modeling of the project, as well as translation to relational model)
• Lab 4b: 2013-05-27 (Implementation of the project)
• The approved project code (queries and stored procedures) should be send to the Urkund addresss jospe.liu@analys.urkund.se. The code should be attached as a file with name coursecode_year_student1_student2.txt (t.ex. TDDD12_2013_jospe50_jospe51.txt). This will be used to detect plagiarism.

For those that did not finish on the dates above, there are two other opportunities:

• August 2013, for labs and projects handed in by 2013-08-24.
• October 2013, for labs and projects handed in by 2013-10-21.
• After these dates, the student has to repeat the whole lab series and project next time the course is given.

Rules for examination of computer lab assignments at IDA

You are expected to do lab assignments in group or individually, as instructed for a course. However, examination is always based on individual performance.

It is not allowed to hand in solutions copied from other students, or from elsewhere, even if you make changes to the solutions. If there is suspicion of such, or any other form of cheating, teachers are obliged to report it to the University Disciplinary Board.

Be prepared to answer questions about detailes in specific code and its connection to theory. You may also be asked to explain why you have chosen a specific solution. This applies to all group members.

If you foresee problems meeting a deadline, contact your teacher. You can then get some help and maybe the deadline can be set to a later date. It is always better to discuss problems, instead of, e.g., to cheat.

Any kind of academic dishonesty, such as cheating, e.g. plagiarism or use of unauthorized assistance, and failure to comply with university examination rules, may result in the filing of a complaint to the University Disciplinary Board. The potential penalties include suspension, warning.

Policy for handing in computer lab assignments at IDA

For all IDA courses having computer lab assignments there will be one deadline during or at the end of the course. If you fail to make the deadline, you must retake the, possibly new, lab course the next time the course is given.

If a course deviates from this policy, information will be given on the course web pages.

Page responsible: Jose M. Peña
Last updated: 2013-04-03