Term Project Spring 2016

Presentation schedule

Term Project 2014

1.       Follow the following steps in your term project:

2.      Choose your teammate (groups of two at most)

3.       Choose a title, e.g. Library Database

4.      Send your team members, project title by email to me. (Deadline April 20) (put “CENG356 Project” at title)

5.      Create a list of data items that will be stored in your project. For example, in library project, you may ask the library. Items need not be put in any order.

6.      Find and list all entities.

7.       Find the attributes of entities (the attributes are data items that you already found)

8.      Define restrictions for each attribute (e.g. Number of digits in student ID, range of values for Age attribute, …)

9.      Define relationships between entities and their types (Explain how you found the type of the relationships)

10.   Create Entity-Relation (ER) model of your database.

11.   Create necessary tables for your database.

12.   Show in which normal forms your tables are.

13.   Design necessary queries based on the requirements of the project

14.   Write necessary SQL commands to create tables and queries

15.   Write a report for your project (put all steps explained above)

16.   Implement your project using a DBMS (Oracle, MS-SQL, MySQL, MS-Access, … )

Evaluation

·         Gathering data items (10)

·         Defining entities, the attributes of the entities, the restrictions on the attributes (15)

·         Relationships (5)

·         ER model (5)

·         Normalization (10)

·         Queries (15)

·         Implementation (15)

·         Report (10)

·         Presentation (15) (is necessary)

 

Ceng 356 Term Projects,2010-2011

For the groups who are not able to present their project on June 13, starting with next week (6th of June to 10th of June), they can present their projects between 10:30-12:00 or 14:00-16:00 to Mrs Roya Choupani or Mr. Tolga Medeni . However you have take appointment via email (Please send your emails both of us).

Rules:

The maximum number of members in a single team is 3. More than 3 students will not be allowed;

All projects will be brought inside of a VmWare player compatible virtual machines (if the students required, a windows XP based, SQL 2008 R2 express edition, Visual studio 2008 and an example system preinstalled virtual machine can be given);

If teams decided to use their own virtual machines rather than windows XP based, SQL2008 and visual studio preinstalled machine (OS, RDBMS and the design language could be different), they will earn bonus points from their projects;

Using MS-Access as database will not be tolerated;

Because of the possible complications of recording virtual machines on DVDs (like reading problems and size of the virtual machine is much greater than on a single DVD), it is required to bring projects with  USB memories.(You may take back your USB memories after publishing your grades);

On your memory you also suppose to bring your project report (as .doc format) and presentation (as .ppt format).

Deadlines For The Project:

The last day for bringing your memories (which will include your Virtual Machines, your project reports and project presentations) is June 10th 2011(Friday)

Your presentations will be on June 13th 2011 (Monday) between 09:30-12:30 and 13:30-17:30

Please check the example project report to prepare your project

Suggested Projects

Eventhough you may choose your own subject, you may also use one of the following projects;

 

1.       University database

Design a database for a university. Assume departments are organized in faculties. Each faculty has a dean who is a member of a department as well. For simplicity you may assume each student has only one major (no double major) and no minor. Design the database including the E-R model, and the relational mode. Using the definition of the normal forms, verify at which normal form level your tables are. Then define and implement necessary queries. Include “find transcript” in your query list.

2.       Company database

A company having some completed projects and some active projects, needs a database to store its data. The database should include information about the employees, their departments, and the projects they are (or have been) engaged in. Design the database using E-R model and relational mode. Develop necessary queries and write them in SQL.

3.       Pharmacy database

A pharmacy has a database of different types of medicine. The pharmacy has some employees and a manager. The database should store the details of all prescriptions brought by patients. The database design requires an E-R design, and a logical design. You need to write necessary queries in SQL.

4.       Music database

A music database stores the list of all singers, their songs, and the albums. Assume a song is not repeated in two albums. For each album we need to store the name, date, and type. The database design requires an E-R design, and a logical design. You need to write necessary queries in SQL.

5.       Stock database

Stock database is used to store the details of goods, their available quantity, their price, and the location where they are stored in the ware-house. The database keeps track of adding new goods to the stock and removing from the stock. The database design requires an E-R design, and a logical design. You need to write necessary queries in SQL.