Закрыт

Database Project

Consider the design of a database for a web site of jokes. Each joke is identified by a unique joke ID, a title, a description of the joke, the date the joke is posted, and a list of tags (each tag is a single word in lower cases). Only registered users can post, read, comment on jokes. Each registered user is identified by a user ID, a password, a first name, a last name, an email, the gender, and his/her age. A user can give at most one review for each joke, and on a particular day, the user can post at most 5 jokes and 5 reviews. Meanwhile, a joke can have no or many reviews. The review given by a user provides a score of “Excellent, Good, fair, or poor” and then a short remark. A user can modify an existing review that she/he gave earlier. One special user called “root” is designated as the administrator user. The root user can ban any other user into a black list. Once banned, a user will not be able to login into the system unless he/she is unbanned from the blacklist subsequently. In addition, each user has two dynamic lists: my favorite friends and my favorite jokes, which can be modified by the user when necessary by insert, delete or update.

. Some simple GUI interfaces are required for each functionality. All functionality must be performed via the interface of your system, direct SQL statement execution via any tools (MySQL workbench) can only be used for debugging purporses.

Based on the reference solution given to Problem 1,

a). Write a relational algebra expression to return those users who have posted “excellent” reviews but never “poor” reviews.

b). Write a relational algebra expression to return those jokes that have been reviewed by all users.

c). Write a relational algebra expression to return the jokes in which ‘John Smith’ gives “excellent” reviews while ‘David Liu’ gives ‘poor’ reviews.

d). Write a relational algebra expression to return those jokes that have been reviewed by both male and female users.

e). Write an SQL query to return the jokes that have been reviewed by all users of age 20.

f). Write an SQL query to return the jokes that have been reviewed ONLY by users younger than 20 (not including 20).

g). Write an SQL query to return the users who posted the most number of jokes on 1/1/2019.

h). Define an SQL view JokesNum that gives the number of jokes each user posts on each day.

i). Write an SQL CREATE ASSERTION statement to force the constraint “one user cannot post more than five jokes per day”.

j). Write an SQL CREATE TRIGGER statement to force the constraint “a user cannot provide more than five reviews per day”.

Квалификация: Программирование баз данных, MySQL, PHP, Архитектура ПО, SQL

Показать больше update mysql database web form godaddy, xml mysql database project sample, quickly update mysql database, database projects for students in mysql, access database project ideas, database project pdf, visual studio 2017 database project tutorial, create database project from existing database, database project ideas for computer science students, database project examples, interesting database project ideas, update mysql database using email, upload file update mysql database, php script update mysql database, free small project php update data database, update mysql database using asp, java database update mysql, vbnet project adding images mysql database, update mysql database using php drop menu, update mysql database via file

О работодателе:
( 6 отзыв(-а, -ов) ) saint clair shores, United States

ID проекта: #18820092

41 фрилансеров(-а) в среднем готовы выполнить эту работу за $161

it2051229

Hi there, I do database development particularly MySQL. I went through the requirements with regards to the "joke" system. I would like to do this project if given the opportunity. Let me know if you are interested.

$100 USD за 3 дней(-я)
(679 отзывов(-а))
7.2
urmate

Hi There I've excellent programming and development skills and knowledge. I can provide an efficient, perfect, well documented development of your Programming and Computer project according to 100% accuracy and Больше

$155 USD за 3 дней(-я)
(281 отзывов(-а))
6.8
jarki2017

Hi I just read your job description carefully. I have 14+ years of strong experiences in MySQL/PHP. So, this job is very easy for me. Please hire me. I can work for you easily Thanks

$250 USD за 3 дней(-я)
(34 отзывов(-а))
6.0
androidc

Hi there, 1. Which payment gateway you want to integrate? 2. Do you also want to add any shipping charges? I have built similar E-commerce Websites. Please have a glance. [login to view URL] Больше

$155 USD за 3 дней(-я)
(104 отзывов(-а))
6.5
yuriyes43

Hi, there! I am very interested in your job. I have been working as a full stack web developer for over 5 years. I am highly skilled in PHP and Mysql so I feel confident that I can do your job without fail. I can s Больше

$155 USD за 3 дней(-я)
(67 отзывов(-а))
6.4
lovethomas1026

Hello! Thanks for your post. I read your requirement carefully. I have rich experienced in DB design. If you give me a chance, I will satisfy you with good result. Please check my profile. I will wait your reply. Больше

$150 USD за 3 дней(-я)
(58 отзывов(-а))
6.2
ChernenkoEgor

I can design the database design and write the sql queries as you want. Higher-quality and faster-delivery is promised. Your job seems to be posted only for me not for the others, because you are looking for only an Больше

$250 USD за 3 дней(-я)
(20 отзывов(-а))
5.9
prakash2813

Hi there, I have strong expertise in database management, plsql, dynamic queries, pivot tables, database normalization, umls and more. I have read the details, this is an easy job for me. Message me, I would like to Больше

$200 USD за 2 дней(-я)
(60 отзывов(-а))
6.1
rukeysolutions

Hello, I have 6 years of experienced on mobile application ( Android +iphone/ ipad ) and App admimn with development web services where admin can manage the app from backend ,. I have developed the TAXI apps, google Больше

$111 USD за 3 дней(-я)
(118 отзывов(-а))
6.1
brightstar928

⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐ Hi I read your job description carefully and I can do your job perfectly. I have developed many websites So I can know what you mean and I am ready for you now. If you hire me, I will finish your job A Больше

$100 USD за 3 дней(-я)
(35 отзывов(-а))
5.7
prasy8

Hi there, Provide all database tables with sample data if you have any. I am Senior Software Developer having 10 years of experience provide quality service. I am full time freelancer usually work on technologies l Больше

$277 USD за 10 дней(-я)
(19 отзывов(-а))
5.4
deividvasquez625

Hello nice to meet you , I am a Computer Engineer and web developer from Venezuela, The project sounds very interesting and I ure would like to help creating those queries, Let me know I can start right now! Thanks

$140 USD за 3 дней(-я)
(26 отзывов(-а))
5.0
ritu3361

Hello, I will deliver the BEST OUTCOME, within the time and budget mentioned. I have checked the description and I would like to have detailed discussion through freelancer chat before we start. I will be here for any Больше

$100 USD за 5 дней(-я)
(16 отзывов(-а))
4.6
crazyunix

how are you today i can work on your project i'm expert in all required skills you are welcome to discuss it with me

$55 USD за 2 дней(-я)
(27 отзывов(-а))
4.1
avto35217

HI there. How are you doing? I am a full stack web developer who has decent experience with most of the javascript frameworks and libraries, and also the php frameworks like CI and Laravel. I am also used to work on ag Больше

$166 USD за 3 дней(-я)
(9 отзывов(-а))
3.8
rashmisingh2990

Hi, I cordially welcome you to my freelancer profile. I'm a long-standing freelancer and I will be pleased if you will give me chance to raise my profile stature with my service and quality. You can settle our paymen Больше

$155 USD за 3 дней(-я)
(18 отзывов(-а))
3.9
eujinong

Hi. I read your job description carefully and I understand your requirements for your database. I am an expert of MySQL and database management with good skills and rich experience. So I can help you with my work no Больше

$150 USD за 1 день
(8 отзывов(-а))
3.6
scar20181206

Hello dear. My name is Sel, I am a fullstack web developer. I read your text carefully and I want to work on your project. I am good at database design and manipulation with MySql for backend and also have much exper Больше

$111 USD за 3 дней(-я)
(9 отзывов(-а))
4.0
Yonasi

Hi, We have well-experienced development team in-house with 15 years of experience. They can do complex and logical Coding. We have served for US (we developed EMR for American client) and EU (developing a fully Больше

$155 USD за 3 дней(-я)
(8 отзывов(-а))
3.5
grozenyku

I have great experience in writing sal queries, store procedures and triggers. I have worked for big companies and I easily can do thus job

$250 USD за 8 дней(-я)
(1 отзыв)
3.0