CE4208 Distributed Systems

CE4208 Distributed Systems

Assignment #1: Data Centred Distributed Systems Assignment

Page 1 of 3

CE4208 Distributed Systems

Data Centred Distributed Systems Assignment

1.Overview

This is an individual assignment, where each student must submit their own solution – any

duplicate solutions will receive 0 marks. Your task is to develop a desktop application that

uses JDBC to connect a database.

If you have any queries, please post them on the “Assignment #1 Data Centred Distributed

Systems” forum on the module’s Brightspace page.

2. DescriptionYour task is to develop your own relational database – this database can store anything youlike. Then, you are asked to provide a desktop application that interacts with your DB via JDBC.

2.1 Database Requirements

Your database must be implemented in the Derby Database (Apache Java DB) and have thefollowing properties:

• Use at least one One-to-One relationship.
• Use at least one One-to-Many relationship.
• Use at least one Many-to-Many relationship (you must use a junction table – the sameelationship as for the One-to-Many cannot be used).

• Use at least one column of the following types: INTEGER, VARCHAR,

DATE/TIME/TIESTAMP (one of these), fixed point number with exactly 2 digits for thefractional component (2 digits to the right of the decimal point – specify your ownlimit for the overall precision).

2.2 Desktop Application Requirements Develop a 代写CE4208 Distributed Systemsdesktop application (not a Web application) that interacts with your database. Useeither dialog methods from the JOptionPane or develop a proper Swing GUI (only advisable if

you have experience with Java Swing).

All database interactions must be implemented by using JDBC. Your application must provide

the following features:

• At start up a method that establishes whether the tables of your database areavailable must execute.

• If they are not available, it should create your tables in Derby:

o Feel free to add your tables to the sample database or create your own logicaldatabase within Derby.

o If you use the sample database, please precede all table names with yourstudent ID to ensure unique table names.

o If you create your own logical database within Derby, please include yourstudent ID in the database name to ensure unique database names.CE4208 Distributed SystemsAssignment #1: Data Centred Distributed Systems Assignment

Page 2 of 3

• Either way, your application must ensure that sufficient data is available in your tables

to allow meaningful execution of your application (as a rough guideline, I would expectmost tables to hold at least 8-10 rows).

• Several methods (one method per bullet point) implementing the following (valuesshould be passed as parameters to the methods):

o A method using a query that uses an explicit join over two tables (feel free touse either a natural join, a join condition, or any of the outer joins).

o A method using a query that involves tables with a Many-to-Many relationship(all tables must contribute to the query result).

o A method adding an entry to the junction table of a Many-to-Many

relationship.

o A method that implements a transaction over (at least) two SQL statements.

o A query/statement as a PreparedStatement that has at least one queryparameter and that executes multiple times within a loop. This method should

eceive values for the parameter(s) in form of an array or Collection (e.g.ArrayList, LinkedList, etc.).

3. Deadline and Deliverables

Deadline for submission of your solution is 11:00h on Monday, 10 th March 2025. Please note:Where I have concerns about the originality of the submitted work, I reserve the right toconduct interviews with students, where marks will be adjusted according to the outcome of

the interview.

Please submit your solution as a single zip, 7-zip or rar archive (please do not use any otherformat and do not remove the extension from the archive) via the module’s SULIS page. Acomplete solution includes the following items:

• Complete NetBeans 24 project that contains sources (well documented andformatted) of your entire solution (submit the entire project folder, not only theindividual source code files!). Comments must include at least the following:

o Description for each class (use Javadoc for this).

o Description for each public member, including details for parameters andreturn value (use Javadoc for this).

o For any non-trivial methods provide “in code” description in form of basic Javacomments.

• Report (MS Word, RTF, PDF or plain text – include this in the top folder of your project)that contains the following:

o Description of your database design (all your tables, their column properties -such as type and constraints - and their relationship to other tables).

o How (and where) you implemented the requested One-to-One, One-to-Many

and Many-to-Many relationships.o List of used queries/statements to fulfil the desktop application requirements.Include class and method name where these are executed, which requirement

they implement.Note: If your report omits any requested information, I assume that the

corresponding feature has not been implemented, and you will receive 0 marksfor that feature. I will not search for those features in your application! For CE4208 Distributed SystemsAssignment #1: Data Centred Distributed Systems Page 3 of 3example, if you do not indicate which tables implement a Many-to-Manyrelationship you will receive 0 marks for that feature even if yourdatabaseimplements this feature. Similarly, if you do not detail where you implemented the

transaction over at least two SQL queries/statements, I assume you did notimplement this and you will receive 0 marks for the transaction feature.

4. MarkingThe project is worth 15% of the module. Marks are distributed as shown in the table below: