Following on from this question last_question with this table `id`, `bbs_id`, `user_id`, `like_dislike`
As sort of a follow up to this previous question: Normalizing a variety of properties with similar data types
Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this question? Update the question so it focuses on one problem only by editing this
Without actually giving all the details of my query: Is there a way of joing the results of two separate queries on different tables?
I am creating a bulletin board application. Each bulletin can be liked or disliked by users of the site.To keep track of the likes and dislikes I have created the following database table
first of all sorry for my bad english hehehe I need some help, I want to design a database for a website, like a mini Amazon. This database will manage every kind of products (TV, cars, computers, boo
I have some confusion while normalizing in 2NF Consider set of FD\'s FD1ABD->C FD2BC->D FD3CD->E
i am trying to build a system that logs, media (photo, video, audio) upload statistic. so i come up with 3 tables, 1 for audio, 1 for video, and 1 for photo. and here\'s the structure
I am wondering is it more useful and practical (size of DB) to create multiple tables in sql with two columns (one column containing foreign key and one column containing random data) or merge it and
Given a schema R (A,B,C,D) with functional dependencies F = {A->B, A->C} I need to determine if R is in 3NF, but first I need to determine what the candidate keys are so I can determine if B and
加载中,请稍侯......