WSU Database Management Systems ER Diagram for A Website Exercise

I’m studying for my Computer Science class and need an explanation.

Consider the design of a database for a web site of a web site of youtube videos (say WSUDIY.com) that teach people how to do things by yourself, such as house renovation. We will call these youtube videos as DIY videos. First, all registered users can post DIY questions, such as “how to paint a wall”. Each DIY question is identified by a question ID, the question itself, and a list of tags (each tag is a lower case word) to annotate the question, and the date the question is posted,. For example, for the question “how to paint a wall”, we can add the tags “wall, paint, roller, brush”. A registered user can also post a DIY youtube video (from the existing youtube.com website) to an existing DIY question. Each youtube video is identified by a unique URL (use the URL when you click the share button at the youtube page, such as https://youtu.be/buSv1jjAels) ,a title and a description of the youtube, the date on which the youtube is posted to your database system. A registered user can search for youtube videos by typing a question (ideally, support fuzzy search since a user might not be able to type the exact phrase in a question), all relevant youtube links will be returned as a list so that a user can click any youtube link in the result list to play that youtube video. Each registered user is identified by a unique username, which must be an email, a password, a first name, a last name, the gender, and his/her birthday. A registered user can give at most one review for each youtube video, but on a particular day, the user can post at most three youtube videos. The review given by a user has a score of {“Poor”, “Fair”, “Good”, “Excellent”} and then a short remark. A user can also modify an existing review as well as deleting an existing review. Each user has a private favorite list of DIY youtubes (called my favorite DIYs). Each user can insert or delete a DIY youtube from that favorite list. When each youtube is shown, the DIY question will also be shown beside the title of the youtube, so that a user can click it to see other youtubes for this DIY question. While a youtube is on display, there is a button under the video called “Add to my favorite DIYs” so that a user can easily add this youtube to his/her favorite DIYs. The system has a distinguished user called “root” whose username is root (this is the only username that is not an email).

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

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

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with MyhomeworkGeeks
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
business
Great job
Customer 452773, February 13th, 2023
History
Don't really see any of sources I provided, but elsewise its great, thank you!
Customer 452697, May 8th, 2021
Business and administrative studies
Excellent job
Customer 452773, March 9th, 2023
Leadership Studies
excellent job
Customer 452773, August 3rd, 2023
ACC/543: Managerial Accounting & Legal Aspects Of Business
EXCELLENT JOB
Customer 452773, January 10th, 2024
Social Work and Human Services
Great work I would love to continue working with this writer thought out the 11 week course.
Customer 452667, May 30th, 2021
Business and administrative studies
excellent job
Customer 452773, March 12th, 2023
Business and administrative studies
perfect
Customer 452773, February 23rd, 2023
BUSINESSADMINECO535
excellent work
Customer 452773, October 6th, 2023
FIN571
excellent
Customer 452773, March 15th, 2024
Human Resources Management (HRM)
excellent job
Customer 452773, June 25th, 2023
Leadership Studies
awesome work as always
Customer 452773, August 19th, 2023
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend
OUR GIFT TO YOU
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat
Close

Sometimes it is hard to do all the work on your own

Let us help you get a good grade on your paper. Get professional help and free up your time for more important courses. Let us handle your;

  • Dissertations and Thesis
  • Essays
  • All Assignments

  • Research papers
  • Terms Papers
  • Online Classes
Live ChatWhatsApp