Đã hoàn thành

Database Help

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

. a). Draw an E-R diagram for the system, in particular, use arrows or thick lines to represent constraints appropriately. Write down your assumptions and justifications briefly and clearly.

b). Translate the above E-R diagram into a relational model, i.e., write a set of CREATE TABLE statements. In particular, specify primary key, foreign key and other constraints whenever possible.

Kĩ năng: Quản trị cơ sở dữ liệu, Lập trình cơ sở dữ liệu, MySQL, PHP, SQL

Xem nhiều hơn: database design, codementor, database experts online, database design guidelines, datagrip create database, uses of database in an organization, database design tutorial, database expert job description, access database help, populate database help, designing database help desk ticket system, drupal friends lists, projects created open office database help, install primavera database help, arc emu database help, neooffice database help, wow database help arc emu, wordpress database help, primavera database help, export facebook friends lists

Về Bên Thuê:
( 1 Nhận xét ) saint clair shores, United States

ID dự án: #18647810

Được trao cho:

valor312

Hello. I have read your description and I am so interested in your project. I am confident in your project and I can finish it clearly on time. I am well experienced and skillful MySQL, MSSQL, Excel, Access and c#, Thêm

$25 USD trong 1 ngày
(7 Đánh Giá)
4.0

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

jarki2017

MYSQL MONSTER HERE!!! ABOUT ME- PLEASE CHECK FOLLOWING QUERIES. ******************************************************************** SELECT id, GROUP_CONCAT(res SEPARATOR ' ' ) AS result FROM (SELECT id, field1, Thêm

$25 USD trong 1 ngày
(34 Nhận xét)
6.0
kaindo2017

I'm a Bsc degree holder in computer science. I have worked on many papers in report writing, research.I have read and understood your requirement and I know you will never regret, thank you.

$100 USD trong 1 ngày
(14 Nhận xét)
4.2
shopshoppy

i can do in 1 hour i can do in 1 houri can do in 1 houri can do in 1 houri can do in 1 houri can do in 1 houri can do in 1 houri can do in 1 houri can do in 1 houri can do in 1 houri can do in 1 hour

$88 USD trong 1 ngày
(13 Nhận xét)
4.7
oshadharanasinge

I'm working as a full stack software developer and i have 3 year experience i think i can handle the what is on your mind to make true. we can negotiate payments

$25 USD trong 1 ngày
(2 Nhận xét)
0.6
ruebdario

Hi,I developer and Analist professional with experiency in PHP Framework Yii and Laravel Experiency in implementation and maintenance of plataform Moodle Manager Database Mysql,postgress,sql server Please me contac Thêm

$30 USD trong 1 ngày
(1 Nhận xét)
0.8
mainHELIOS

⭐⭐⭐⭐⭐⭐⭐ Hello Sir. This is simple for me. No Problem. I will help you with the code understanding and any question you have I will answer fully. Looking forward for your response. Best Regards.

$20 USD trong 0 ngày
(1 Nhận xét)
1.0
barragan180497

Hello friend, I would like to work for your project, I have good knowledge in database in SQL Server. I hope you hire me. Thank you

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

I've been working as a Virtual Assistant for 4 years, 2 years in a company and 2 years freelancer. I can handle multiple task, ability to solve problems, produce high quality work. I strive to understand client needs a Thêm

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

Hi I work in top Chinese stat-owned Enterprise, professional in data immigration & data query. expert in mySQL, postgreSQL, I have experiences in processed billions of data every day.

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