Exam timetabling database system

In Progress

A. Design (25%)

Topic for my database system development: Exam Timetabling database system

1. Describe the proposed system in words (max one page)

2. Develop a UML class diagram for your system

- based on your diagram, briefly discuss, domain, super key, primary key, associations (relationships), multiplicity (or cardinality), in the context of your database system (i.e. give relevant examples)

3. Develop a Scheme based on your class diagram

- with reference to your scheme, identify and describe, candidate key, primary key, foreign key, referential integrity, surrogate key and (if relevant) external keys

4. Write the SQL commands to create the database, create and populate tables, query individual tables. (You must include the SQL script in your document - cut and paste queries and results from mysql). Be prepared to defend your choice of data types for selected fields, and any 'not null' fields.

Your design must include at least one many-to-many (M:M) relationship, and one 1:M relationship.

B. Queries (25%)

Write SQL Queries to interrogate your own database. In each case you must write in English what each query does followed by the appropriate SQL Query. Show the output also.

ie. 1. Show the names of all teenagers.

select firstName, lastName from students

where age >= 13 and age <=19;

firstname lastname Jack Pale

Jill Hill

You suite of queries must include at least one query involving each the following:

SELECT all columns, select subset of columns, ORDER BY, DISTINCT, GROUP BY, LIMIT, WHERE clause, logical operators AND/OR, a selection of 5 functions (e.g sum(), ucase(), INNER JOIN, LEFT JOIN). INSERT, DELETE, UPDATE.

(Portfolio Stage 2) 50%

C. Use-Cases (25%)

Identify 4 use-case scenarios that involve transactions that are applicable to your database. Sketch the user interface that might be used for each transaction - identifying fields that are entered by the user, and those filled in by the software system. Wherever data is retrieved from or inserted (updated or deleted) from the database, you must write the appropriate SQL Query. Briefly describe what the software system does (e.g. get current date from computer system to insert into DATE field of books loan database). (Low marks for all trivial queries)

Examples of transactions:

a. Simple - add a new customer to the Customers table

b. Place an order ( customer ID to be obtained, order details to be entered, orders table INSERT)

c. Calculate total cost of job X by employee.

d. Change a flight schedule.

D. Indexing (10%)

Implement appropriate indexes in your database, explaining why the indexes were selected. Briefly discuss the pros and cons of indexing in the context of your database. This should form a section in your Portfolio. (A minimum of three indexes are required.)

E. Views (15%)

Create at least TWO views on your scheme, and explain why they are appropriate for your scheme. Query the views to demonstrate their use.

3. Java Database Connectivity

Implement sample Java code to read data from your database table(s) and display the data on screen. Give a brief description of what you have done and include your code in the document. (Java code to be used on Net beans)

Deliverables

A. Portfolio Document

A.1 - One .pdf document, with Table of Contents, containing all code, diagrams and descriptions. Include your name and class, module name, and date at the top of document.

A.2 - One .SQL Script (text file) containing all the SQL Script to create, populate and demonstrate your database. (This should execute with no errors.)

A.3 – Java Project Source code.

Skills: Database Administration, Java, MySQL, SQL

See more: exam timetabling system java, timetabling, why use use case diagrams, why use case diagram, what is use case diagrams with examples, what is use case diagrams, what is use case diagram, what is uml design, what is the use case diagram, what is a use case diagram, what is an use case diagram, what are use case diagrams, user case diagrams, user case diagram, use of use case diagram, used case diagram, use case types, use case to class diagram, use cases diagrams examples, use cases diagrams, use cases diagram examples, use cases diagram, use case module, use case include, use case diagrams sample

About the Employer:
( 0 reviews ) Ireland

Project ID: #4407395

Awarded to:

dobreiiita

Hi, I am Java expert and can surely help you here, Thank You

€6 EUR / hour
(183 Reviews)
6.4

8 freelancers are bidding on average €6/hour for this job

codeware1

Hello , Hope you are well and doing good!!! we are eager to work with you.We are ready to start the project right away. Codeware is a website development company providing professional website design, website developme More

€4 EUR / hour
(6 Reviews)
4.2
PerfectSquare

Hi I am interested and I have 8 years of UML designing experience, I can do this very easily, I will do with 100% perfection, Let start please Thanks

€3 EUR / hour
(12 Reviews)
3.5
sjhenterprises

let me help you

€8 EUR / hour
(2 Reviews)
2.9
ITACEConsultants

Dear Customer, We have 13+ years of Java/J2EE experience with quiet a lot projects we used mysql. Furthermore,we did both application and DB design by ourselves. We are sure we can deliver this engagement to your sa More

€4 EUR / hour
(2 Reviews)
1.4
dasfreelancer

Hi There, I have gone through your project requirements carefully. It seems that you are trying to make the examination system automated through an application. For some you have given a second part regarding order/cus More

€8 EUR / hour
(0 Reviews)
0.0
murthytumuluri

Hi I have been working for projects like GE from past 5 years on sQL as a data base admin. i am pretty confident that i can complete your project.

€3 EUR / hour
(0 Reviews)
0.0
pratikindia

Hi, 6+ years of experience in Java development. Made many enterprise grade projects for respected clients. Your project will be delivered within a week with all your requirements. Thanks

€8 EUR / hour
(0 Reviews)
0.0
ravindranitwal

I have worked on multiple databases for 3.5+ yrs. I have worked on SQL Server, Netezza, MY SQL etc. I have also worked on many client facing projects. I have good knowledge as a developer and an administrator. I would More

€4 EUR / hour
(0 Reviews)
0.0
JorgeRG

Ready to help with this database system exam.

€6 EUR / hour
(0 Reviews)
2.4
tanujkathuria

Java developer with Good experience.

€4 EUR / hour
(0 Reviews)
0.0