Design database for The University

Closed Posted 5 years ago Paid on delivery
Closed Paid on delivery

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).

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

Database Administration Database Development Database Programming MySQL SQL

Project ID: #19026138

About the project

12 proposals Remote project Active 4 years ago

12 freelancers are bidding on average $22 for this job

writinginvaderz

Invaders is a group of independent professional writers and website developer and scholars from everywhere throughout the world. Together, we give best quality aid to secondary school, undergraduate, Masters and Ph.d More

$17 USD in 10 days
(2 Reviews)
3.6
MubashirAs62

Hello, I have read you are looking for some help regarding database, please refer to my profile and let me know how I can help you with it, feel free to discuss anything, Hopefully you will get your desired work, Thank More

$13 USD in 10 days
(7 Reviews)
2.8
Artelele

Greetings, i'll be glad to work on your project. I'm a software architect and i have a MASTER in Complex Software Engeneering. database modeling is in the center of my studies and my abilities, so i'm really at eas More

$50 USD in 1 day
(2 Reviews)
1.6
vw7114083vw

Having 14years of experience in developing web and desktop based applications. I have gone through the requirements and able to develop the application using ms SQL and asp.net.

$35 USD in 5 days
(1 Review)
0.5
ogovw

I design database on MSSQL and send you as database backup. Some technical details of the project should be determined before starting the project. For example, where files and images that are uploaded by users are More

$15 USD in 3 days
(0 Reviews)
0.0
harshitrathione

SQL development is my strong point, fixing bugs or new requirements are my key area with meeting deadlines as my habit with current job, available as long as it takes to clear the project as I want to prove that I am r More

$15 USD in 15 days
(0 Reviews)
0.0
touristted

I have experience in database design in IT company. With my diligence, I will help you design a database at the earliest following the best practices and normalisation principles. Relevant Skills and Experience 1+ yea More

$17 USD in 3 days
(0 Reviews)
0.0
VishalAgrawal11

Hi,I have read your requirements of Design database for The University and I’m pretty confident that I will be able to get your work done within the given time your requirements conclude.I am very keen to discuss furth More

$16 USD in 11 days
(0 Reviews)
0.0
sunilmudunuri

I'm an experienced freelancer database and report design, development and optimization with 10 years of experience . I have used Erwin tool for data modelling and i am well-versed with Normalization's for doing DB desi More

$17 USD in 10 days
(0 Reviews)
0.0
Chauhanvijay117

I have an experience of more than 6 years,I have implemented multiple end to end projects roght from data ingestion to data visualization. I have also worked on data governance projects , which has enabled me to define More

$20 USD in 10 days
(0 Reviews)
0.0