Ditutup

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

I will provide 2 zip files to understand the project better by request (I was not able to attach them through freelancer):

[url removed, login to view] consists [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view] 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

[url removed, login to view] consists [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view]; AdminSchReader folder which consists [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view]

________________________________________

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: [url removed, login to view]) 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 [url removed, login to view] or [url removed, login to view]

• The tables in the Courses Database will be used for the ScheduleReader Systems are (Refer to the word document [url removed, login to view] 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 [url removed, login to view] file and also FOLDER TablesDataCSV consists 10 files with the CSV data of tables

• Application Queries provided in [url removed, login to view] 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 ([url removed, login to view]), Include header ([url removed, login to view]), body([url removed, login to view] ) & Footer ([url removed, login to view]) ; 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.

Kemahiran: CSS, HTML, Javascript, JSP, SQL

Lihat lebih lanjut: web interface postgresql, to level, tips freelancer, systems freelancer, static interface, sql queries freelancer, site web flat design, search freelancer name, postgresql freelancer, perl web freelancer, perl script zip files, oracle java freelancer, oracle header, oracle application freelancer, oracle admin freelancer, login error freelancer, linked on, linked it, linked i, linked freelancer, level two, level design freelancer, level 2, job freelancer site, javascript level freelancer

Tentang Majikan:
( 0 ulasan ) Secaucus, United States

ID Projek: #1573213

1 pekerja bebas membida secara purata $200 untuk pekerjaan ini

passionatejava

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 dalam 40 hari
(0 Ulasan)
0.0