Completed

Design database for The University System

I need freelancer design database on MSSQL for Specification:

------------------------------------------------------

You are required to build a web-based secure role-based system for collecting student contributions for an annual university magazine in a large university.

The system must meet the following criteria:

• The University has a Marketing Manager to oversee the process.

• All Faculties have a Marketing Coordinator who is responsible for managing the process for their Faculty.

• All students have the opportunity to submit one or more articles as Word documents to the magazine.

• All students can also upload high quality images, e.g. photographs.

• All new contributions are disabled after a closure date for new entries, but updates can continue to be done until a final closure date.

• All students must agree to Terms and Conditions before they can submit.

• Once a contribution is submitted the system emails a notification to the Faculty’s Marketing Coordinator, who must make a comment within 14 days.

• A Marketing Coordinator can only access contributions by students in their Faculty.

• Each Marketing Coordinator needs to be able to interact with the students in their Faculty in order to edit the contributions and to select those for publication.

• The University Marketing Manager can view all the selected contributions but cannot edit any. They need to be able to download all the selected contributions after the final closure date in a ZIP file for transfer out of the system.

• An administrator maintains any system data, e.g. closure dates for each academic year.

• A guest account for each Faculty can be used to view the selected reports.

• Statistical analysis (e.g. number of contributions per Faculty) needs to be available.

• The interface must be suitable for all devices (eg mobile phones, tablets, desktops).

------------------------------------------------------

Skills: Database Administration, Database Development, Database Programming, MySQL, SQL

See more: student management system database design, university database er diagram, college database schema, college management system database tables, database design for college management system pdf, university database design example, student database design example, university database management system, design database library system netbean, design database university managment, software design database design system analysis, database design project travel reservation system, steps design database hospital managment system, database design project conference booking system, design database hotel booking reservation system, design database invoice import export system, mysql database design online flight reservation system, database design structure example reservation system, design database order entry system, database design documentaion school management system

About the Employer:
( 3 reviews ) Hanoi, Vietnam

Project ID: #19026198

Awarded to:

Haloooooo

give a chance for my first project - - . ...................................................................................

$25 USD in 1 day
(0 Reviews)
0.0

6 freelancers are bidding on average $482 for this job

xtremewebtech

hy! Dear how are you? hope you will be fine. i read your project description i am ready to doing this so please come in chat without wasting time so that we can start working quickly. i have good command in php, mys More

$555 USD in 20 days
(20 Reviews)
6.0
OWDGroup

Hi, I'm a database architect and programmer having more than 15 years of experience with different types of domains like telecom, banking, payroll, crm, ecommerce etc with high data volumes and I'm experienced with More

$322 USD in 4 days
(4 Reviews)
3.2
adilabbass

Hey there

$555 USD in 25 days
(1 Review)
2.2
ravneets24

Hi, i can do any php and codeigniter work efficiently. I am an experienced freelancer website developer.

$833 USD in 50 days
(0 Reviews)
0.0
rinfoapp

I can design your database. I have practiced my design and development of application for more than 14 years ... see you soon

$600 USD in 23 days
(0 Reviews)
0.0