Computers and Technology, 13.05.2021 21:00 othello58

Consider a social network database, about people and their relationships. The database has two relations: Person(pid, name) Relationship(pid1, rel, pid2) Here Person. pid is a key, and Relationship. pid1 and Relationship. pid2 are foreign keys; rel is a string representing the relation type, and can be friend or enemy. Note that the relationship is not necessarily symmetric: if Alice is friend with Bob, this does not imply that Bob is friend with Alice. Write the SQL statements that define the relational schema for this database. Assume that pid's are integers, and name and rel are character strings.

Answers: 3

Show answers

Other questions on the subject: Computers and Technology

Computers and Technology, 22.06.2019 16:00, sdonachy7

You have inserted new slides based on a word outline. how do you format these new slides to match the powerpoint presentation formatting? a. select all slides in the presentation and click format on the home tab. b. select the new slides and click reset on the home tab. c. select all slides in the presentation and click reset on the home tab. d. select the new slides and click format on the home tab.

Answers: 3

continue

Computers and Technology, 22.06.2019 23:00, brookerebman15

Which type of tab stop is most for weights and measurements?

Answers: 1

continue

Computers and Technology, 23.06.2019 07:00, Dvrsug8598

You need a quick answer from a coworker. the most effective way to reach your coworker is through a. cloud server b. instant message c. teleconference d. telepresence

Answers: 1

continue

Computers and Technology, 23.06.2019 07:00, lin550

Why were most movies from the late 1890s until the early 1930s only filmed in black and white? there were only a few people who could afford the technology to produce color motion pictures back then. audiences did not want color motion pictures until later. the film used to make color motion pictures often overheated, which was a safety hazard, so it was generally not allowed. color films had to be hand-colored, frame by frame.

Answers: 3

continue

You know the right answer?

Consider a social network database, about people and their relationships. The database has two relat...