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.