Term Project Report COP 4710 Application: College Event Website (CEW) Format and Submission Summary Groups: all groups Format: report file in pdf Software: in appropriate format, e.g., *.sql, *.c, *.txt, etc. One compressed file: all contents in one folder (and subfolders), compressed to CEWGroup.zip, where Group is the appended last names of all members (no space in between). Submission: upload the file to the Term Project assignment by the due date. ONE group, ONE file. Report Contents Project Title and Group Information: o Title: Group Report, Project Name, e.g., College Event Website o Course information: course number, section, term o Group information: group members o Table of contents: GUI, ER-Model, constraints, relational data model, 3NF decomposition (if required), demo, etc. Project description, additional assumptions, if any (to simplify the implementation or to make the project more realistic). GUI: Platform, languages, DBMS, screen shots of Create RSO, Create Event, View Events, etc. ER-Model: ER diagram, constraints captured in the ER-model and other general constraints to be enforced by other means, such as assertions, triggers 3NF decomposition (if required) The relational data model in SQL: CREATE TABLE, CHECK, CREATE ASSERTION, CREATE TRIGGER, as required. Populating tables with sample data: for example: two universities, 20 students, 3 RSOs, five events, three comments, etc. IMPORTANT: integrity of data must be maintained, i.e., all constraints must be enforced, including no overlapping events, active RSO must have at least five members SQL examples and results: o SQL statement to insert a new RSO (part of the processing of the Create RSO form). Show results. o SQL statement to insert a new student to an existing RSO (part of the processing of the Join RSO form). Show results. o SQL statement to insert a new event (part of the processing of the Create Event form). Show results. o SQL statement to insert/update a (new) comment (part of the processing of the Create/Add/Modify Comment form). Show results. o Several SQL queries to display eventspublic, private, and RSO (part of the processing of the View Event. request by a user with a specific role). Show results. o SQL statements of interest (optional), e.g., advanced SQL queries Constraint Enforcement: Show SCREENSHOTS of error messages/warnings when the following events/attempts are made: o A new event to be held at the same location and overlapping times with an existing event: Show error message with enough detail such as the conflicting event, time, location, etc. o An admin who is not the Admin of the RSO attempts to create an event for that RSO: Show an error message. o An INSERT of a member of an RSO with 4 members: Show the status of the RSO changing to Active. A DELETE of a member of an RSO with 5 members: Show the status of the RSO changing to Inactive. Advanced Features: If implemented, briefly describe the features, and show screenshots. If the demo was not as expected (i.e., crash, something failed, produced wrong results, etc.), and your team promised the problems could be fixed, discuss what you did here, including the new code, the results and their screenshots. Conclusion/Observation: o Database performance: query response time, suggested indexes o Desired features/functionalities: security (login), event feed from university websites (e.g., XML feeds from http://events.ucf.edu/), social network integration (Facebook, Twitter, etc.) o Problems encountered, things that have been learned from the project, more things/skills needed to master to build a more advanced database app. In retrospect, what are the things you would have done differently to implement the project? Folder Contents Group Report Subfolder: contains the source code and (if open-source) required libraries to run the app (in appropriate format, e.g., *.sql, *.c, *.txt, etc.). A *.sql file containing SQL statements to set up the environment (database name, user, password, etc.) and create the database (CREATE TABLE, but no sample data needed, i.e., no INSERT statements) is to be included here. (You can accomplish this by exporting the database, not the sample data). Software installation: installation instructions Submission One compressed file: all contents in one folder (and subfolders), compressed to CEWGroup.zip Submission: upload the file to the Term Project assignment by the due date. ONE group, ONE file.
We offer the best custom writing paper services. We have answered this question before and we can also do it for you.
GET STARTED TODAY AND GET A 20% DISCOUNT coupon code DISC20
Why Choose Us
- 100% non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee
How it Works
- Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the "PAPER DETAILS" section.
- Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
- From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.