Đã hoàn thành

Database Help Needed

I run a speaking and training company where people watch live and recorded webinars that I provide.

I have two types of members: Agencies & Individuals.

To access the training they fill out forms though a service I use called PaperForm ([login to view URL]).

For Agency members watching Live Webinars I collect the following information:

* First Name

* Last Name

* Email Address

* Organization (they select their organization from a pre-determined drop down list)

* Topic (This is also pre-determined)

For Agency members watching recorded webinars I collect the following information

* First Name

* Last Name

* Email Address

* Organization (they select their organization from a pre-determined drop down list)

* Topic (They select the topic from a pre-determined drop down list)

For Individual members watching Live Webinars I collect the following information:

* First Name

* Last Name

* Email Address (This is the field I used to identify & validate individual members)

* Topic (This is pre-determined)

For Individual members watching Recorded Webinars I collect the following information:

* First Name

* Last Name

* Email Address (This is the field I used to identify & validate individual members)

* Topic (They select the topic from a pre-determined drop down list)

Here is where I need your help. I want to automatically take the information collected from these forms and put it into a database where different roles can view the data collected from the form.

Here are the roles and what I want them to see:

Role - Admin (editing and viewing permission) - This is me

- Total live webinar views by all agency and individual members

- Total recording views by all agency and individual members

- Total views (live and recorded webinars)

- Live webinar views broken down by agency

- Recorded webinar views broken down by agency

- Live webinar views broken down by individual members

- Recorded webinar views broken down by individual members

I also need the ability to manually add information to each field in the database as necessary, and upload files to populate the database as necessary.

Role - Agency Key Contact (viewing permission)

- Total Views (Live webinars and recordings) by their organization (and only their organization)

- Total Live webinar views by their organization (and only their organization)

- Total Recording views by their organization (and only their organization)

- Training Views by Topic: Live Webinars (which specific staff members viewed each unique live webinar)

- Training Views by Topic: Recorded webinars (which specific staff members viewed each unique recorded webinar)

Agency key contacts should only see the first and last names of their staff who attended. No emails.

I will provide a list of existing key contacts.

For login, I want them to log in with their email only. No password necessary.

Role - Individual Member (viewing permission)

- Total Views (Live webinars and recordings) by the individual

- Total Live webinar views by the individual

- Total Recording views by the individual

- Training Views by Topic: Live Webinars - which specific live webinars did the individual watch

- Training Views by Topic: Recorded webinars - which specific recorded webinars did the individual watch

For login, I want them to log in with their email only. No password necessary.

In terms of the database, my only requirement is that I own whatever database that is used. I also need to keep costs low, so something free, open source or low cost is preferred. Google BigQuery may meet this need? Since you are a database professional, you will know this better than I do.

For reference, PaperForm currently has integrations with these database providers: [login to view URL]

Kĩ năng: Phát triển cơ sở dữ liệu

Xem nhiều hơn: excel project help needed, getafreelancer message sql query help needed, python projects help needed, importance of database management system in business, business database example, importance of database in business, how to start a database business, database impact on the workplace, database for small business, uses of database in an organization, benefits of database, marketing help needed, photography portfolio help needed, visual start help needed, database conversion needed, programmers help needed, virtuemart help needed, salesforce help needed, help needed readers writers, add emails add contact list gmail yahoo

Về Bên Thuê:
( 6 nhận xét ) Minneapolis, United States

ID dự án: #19881655

Được trao cho:

wonwon424

Hi, employer. I am very familiar in database programming and processing. i have built many database management systems I've read your proposals carefully and I think I can do it. I have many previous works in this wor Thêm

$555 USD trong 15 ngày
(0 Đánh Giá)
0.0

20 freelancer đang chào giá trung bình $472 cho công việc này

fanninson45

INTRODUCTION I am an experienced Professional with Database Programming and Administration skills across MySQL, MS SQL and Business Intelligence Development. I can assist you with your database modelling and developm Thêm

$500 USD trong 7 ngày
(18 Nhận xét)
5.9
schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl Thêm

$500 USD trong 7 ngày
(3 Nhận xét)
3.9
dgled

I can suggest to you a module in Microsoft Excel which enables to upload and/or add/update records on flexible bulletin forms. Excel validates and manipulates the information (add formulas), and keep the form in the m Thêm

$750 USD trong 7 ngày
(1 Nhận xét)
3.6
xinglong717

Hi. I've read carefully your job description I have a lot of experiences in JAVA, C, C++, VB, DATABASE, SQL QUERY,... And I also have experiences in Excel VBA developing and data mining. If you hire me, then I will tr Thêm

$350 USD trong 7 ngày
(2 Nhận xét)
2.6
sashaE319WebGuru

Hello. How are you? I have just read your post and interested in this job. As an experienced web developer, I am sure I can handle your project perfectly in the quick timeline. Let me know if you have some time to d Thêm

$555 USD trong 10 ngày
(1 Nhận xét)
2.4
valiksoin

Dear Sir. I read your post carefully. I want to discuss more detail on chat . I will provide greate service and good result. Reguards,

$500 USD trong 7 ngày
(0 Nhận xét)
0.0
arundv94

I have a very good experience in database development and database programming .I had a experience of handling multiple databases simultaneously in multiple platforms .I have good knowledge in python

$250 USD trong 10 ngày
(0 Nhận xét)
0.0
aap31374

I have more then 15 years of experience in DBMS and immediately available to work with you

$555 USD trong 10 ngày
(0 Nhận xét)
0.0
TakaAlex

Hi Dear!... You just found bright shine like star in here. I will bring you good luck. Don't worry about your project. I have over 7 years experience of this development. I have enough passion , strength and endur Thêm

$555 USD trong 10 ngày
(0 Nhận xét)
0.0
shenji108

Hello, I'm Android (since 2012) and web (since 2013)developer. I can speak in English freely. I tend to keep myself up to date with important changes in the Android world and web frameworks and regularly look into ne Thêm

$500 USD trong 5 ngày
(0 Nhận xét)
0.0
bluebear1888

Hi Dear!... You just found bright shine like star in here. I will bring you good luck. Don't worry about your project. I have over 7 years experience of this development. I have enough passion , strength and endu Thêm

$555 USD trong 10 ngày
(0 Nhận xét)
0.0
Molotova

Greetings,I'll do my best to perfect your project. I can develop you the desired work with the main focus on it quality. I have strong expertise over HTML, Javascript, PHP, DB Management. I am highly interested i Thêm

$250 USD trong 10 ngày
(0 Nhận xét)
0.0
sotnikovuri

Hello! How are you? Please visit [login to view URL] in my profile. As you can see my skill on this project I have deep experience of web development with high quality pixel-perfect design in more 9 years. I read Thêm

$555 USD trong 10 ngày
(0 Nhận xét)
0.0
idragon712

Hi Sir. I have read the description of your project and I am great interested in your job. because I am very familiar with structuring a database(including Google BigQuery) I am a senior web developer with more than Thêm

$500 USD trong 10 ngày
(1 Nhận xét)
0.0
maximwang8661

MIN COST! MAX QUALITY! Hello? I read your project . Your project is very interesting. I have ever been similar project with your project. I have 8+ years of experience working with Web design,Scraping,data entry, and G Thêm

$300 USD trong 3 ngày
(0 Nhận xét)
0.0
WangYingDBA

Hello! You don't need find any more another developer. I suggest that you makes with PHP Framework as for Open source type. That is awesome & low-costs. My previous working. ************************************* h Thêm

$300 USD trong 7 ngày
(0 Nhận xét)
0.0
langlangFan

Hi, thanks for your job posting. I have developed several websites similar to your requirements. I am good at database design and development. Frankly to say, I have 10+ years of software experience. The most important Thêm

$500 USD trong 7 ngày
(0 Nhận xét)
3.1
jiangjiabao

Hello. I read your project very carefully and I am ready to start working on it. I am an expert with all the skills which you mentioned in your project description. If you want I can provide some test work to make y Thêm

$400 USD trong 7 ngày
(0 Nhận xét)
0.0
LiaoFang

Dear client. Nice to meet you. My name is ZeMin. Thanks for your job posting. I've read you project description carefully and very interested. Let's discuss over chat and get started. Waiting your reply. Warm regards Thêm

$500 USD trong 7 ngày
(0 Nhận xét)
0.0