Find Jobs
Hire Freelancers

Exam timetabling database system

€2-6 EUR / hour

Σε Εξέλιξη
Αναρτήθηκε περίπου 11 χρόνια πριν

€2-6 EUR / hour

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.
Ταυτότητα εργασίας: 4407395

Σχετικά με την εργασία

8 προτάσεις
Απομακρυσμένη Εργασία
Ενεργός/ή 11 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα
Πληρώσου για τη δουλειά σου
Περίγραψε την πρόταση σου
Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν
Βραβεύτηκε στον/στην:
Avatar Χρήστη
Hi, I am Java expert and can surely help you here, Thank You
€6 EUR σε 15 ημέρες
4,7 (419 αξιολογήσεις)
7,4
7,4
8 freelancers δίνουν μια μέση προσφορά €6 EUR/ώρα για αυτή τη δουλειά
Avatar Χρήστη
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 σε 25 ημέρες
4,8 (21 αξιολογήσεις)
4,0
4,0
Avatar Χρήστη
let me help you
€8 EUR σε 20 ημέρες
5,0 (2 αξιολογήσεις)
2,9
2,9
Avatar Χρήστη
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 σε 45 ημέρες
5,0 (1 αξιολόγηση)
1,0
1,0
Avatar Χρήστη
Java developer with Good experience.
€4 EUR σε 3 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
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 like to work on thos project. Thanks, Ravindra Singh
€4 EUR σε 16 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
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 σε 20 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
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/customer/job/employee etc. which is confusing - sorry to say. For the other part I am proposing a simple plan in the PM. Please take a look and let me know what you think.
€8 EUR σε 12 ημέρες
0,0 (0 αξιολογήσεις)
2,1
2,1

Σχετικά με τον πελάτη

Σημαία της IRELAND
Ireland
0,0
0
Επαληθευμένη μέθοδος πληρωμής
Μέλος από Απρ 7, 2013

Επαλήθευση Πελάτη

Ευχαριστούμε! Σου έχουμε στείλει ένα email με ένα σύνδεσμο για να διεκδικήσεις τη δωρεάν πίστωση σου.
Κάτι πήγε στραβά κατά την προσπάθεια αποστολής του email σου. Παρακαλούμε δοκίμασε ξανά.
Εγγεγραμμένοι Χρήστες Συνολικές Αναρτημένες Δουλειές
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Φόρτωση προεπισκόπησης
Δόθηκε πρόσβαση για Geolocation.
Η σύνδεση σου έχει λήξει και τώρα έχεις αποσυνδεθεί. Παρακαλούμε συνδέσου ξανά.