Find Jobs
Hire Freelancers

e-Commerce site linked to a db. level: college undergrad

$30-250 USD

Κλειστή
Αναρτήθηκε περίπου 12 χρόνια πριν

$30-250 USD

Πληρωμή κατά την παράδοση
I will provide 2 zip files to understand the project better by request (I was not able to attach them through freelancer): [login to view URL] consists [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL] and FOLDER TablesDataCSV consists 10 files for 9 TABLEs (2 files for crs_sec_schedule_reader TABLE; 1 file with NULL start_date and end_date; 1 file with NOT NULL start_date and end_date) with the CSV data of tables and DirectoryLink folder with two csv files with directory information. It has the directory oid and webgrade dept info inside TablesDataCSV\DirectoryLink [login to view URL] consists [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL]; AdminSchReader folder which consists [login to view URL], [login to view URL], [login to view URL], [login to view URL] ________________________________________ Project Database Specifications: • Currently data for the system comes from mainframe via a flat file called RG131 • A cron-job on the WebServer transfers the file RG131 • The cron job runs every hour to see if the data on the MainFrame has been updated and then transfers it. It runs every 15 minutes during the hours of 2 AM, 3 AM, 9 AM, 10 AM, 12 PM, 1 PM, 4 PM, 5 PM. The Front Page on the web (page name: [login to view URL]) will display the updated time and date. Sample Data on the PostGreSQL Database: Few files are transfered to the Database server as a flat file thru a cron job once the data is updated on the WebServer. Few perl scripts parses the data and insert to tables to the COURSES database thru a cron job. Note: The Semester begin and end date format in the database will be will be yyyymmdd Each data will be surrounded by "|". If no data exists eight zeros will be displayed "00000000" or null • The complete database can be build in Oracle thru [login to view URL] or [login to view URL] • The tables in the Courses Database will be used for the ScheduleReader Systems are (Refer to the word document [login to view URL] ERD for the Data Model):course_schedule_reader, crs_comments_schedule_reader, crs_sec_schedule_reader, discipline_schedule_reader, instructor_schedule_reader, semester_schedule_reader, dept_schedule_reader, update_time_schedule_reader, admin_user_schedule_reader • Sample data set provided in the [login to view URL] file and also FOLDER TablesDataCSV consists 10 files with the CSV data of tables • Application Queries provided in [login to view URL] file Note: The search criteria or join should be based on crs_cd and semester as a composite primary key ________________________________________ Task Distribution • Java Script, Server side Error ([login to view URL]), Include header ([login to view URL]), body([login to view URL] ) & Footer ([login to view URL]) ; Build Database • Primary page • Result Page • Course Description Page • Admin Interface with Authentication - Update Database on the courses.semester_schedule_reader(start_date, end_date) table Tips: • Only JSP coding no design changes except anything specified • All the data should be represented through dynamic query. No static data value from the database should be referenced to the application since dataset can be changed at any time.
Ταυτότητα εργασίας: 1573213

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

1 proposal
Απομακρυσμένη Εργασία
Ενεργός/ή 12 χρόνια πριν

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

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

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα
Πληρώσου για τη δουλειά σου
Περίγραψε την πρόταση σου
Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν
1 freelancer δίνει μέση προσφορά $200 USD για αυτή τη δουλειά
Avatar Χρήστη
I have 6 years of extensive experience in java/j2ee. Currently working on Spring project. I would like to work on this project.
$200 USD σε 40 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0

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

Σημαία της UNITED STATES
Secaucus, United States
0,0
0
Μέλος από Απρ 18, 2012

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

Άλλες δουλειές από αυτόν τον πελάτη

e-Commerce linked to a db. level: college undergrad
$250-750 USD
Ευχαριστούμε! Σου έχουμε στείλει ένα 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.
Η σύνδεση σου έχει λήξει και τώρα έχεις αποσυνδεθεί. Παρακαλούμε συνδέσου ξανά.