Question: You are asked to use Entity Relationship Model to design a database for a small social network The database should store information about: Person is

You are asked to use Entity Relationship Model to design a database for a small social network The database should store information about: Person is identified by unique number (PID), and its detail information is name, date of birth gender, email phone, and job. Account is identified by unique number (AID), and its detail information is username, password and email. Post is identified by unique number (Pol), and its detail information is date, time, description, and keyword. Photo is identified by unique number (Phid), and its detail information is caption keyword, size, and dimension An account is owned by a person, and a person can own only an account. A person can have relationship with many other people (person). A post is owned by a person, and a person can own many posts. A photo belongs to a person, and a person can own many photos A post can associate with many photos, and a photo can associate with many posts. (Non-anonymous question) (25 Points)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Indicate whether each of the five statements presented below is true or false. If false, indicate how to correct the statement. The three steps in the accounting process are identification,...

CIS 3650 Database Management Systems 2. Entity relationship diagram that documents the database design. The diagram should use the Fall 2022 Group Project appropriate crow's foot notation including...

A PROJECT DILEMMA AT CANADIAN SHIELD INSURANCE Derek Stacey, David Hemsworth, Glenn Brophey and Cristobal Sanchez-Rodriguez wrote this case solely to provide material for class discussion. The...

1. The CS department needs to store information about instructors (identified by ssn, with salary and officenumber as attributes), courses (identified by cno, with cname and time as attributes), and...

What you need to do: 1. Please prepare an ER diagram based on the following information gathered during interviews conducted with users. Please indicate the entities, attributes, primary keys, and...

CREATE ER DIAGRAM WITH YOUR HAND ON PAPAER BASED ON INTERVIEW NOTED AANSWER MUST BE SIMILAR LIKE THIS WORK. What you need to do: 1. Please prepare an ER diagram based on the following information...

Good afternoon, I have a question about my CIS database management class assignment. Below are the questions. And under the quest is how it should be formatted. Thank you so much! Create a conceptual...

Project Description/Background NU Hospital Mission statement: The purpose of the NU Hospital database application is to maintain the data that we generate and to provide an efficient, effective, and...

A soft drink bottling company maintains records concerning the number of unacceptable bottles of soft drink from the filling and capping machines. Based on past data, the probability that a bottle...

Determine the seepage in m3/day through the homogeneous earth dam depicted in Figure 7.29. Also determine the seepage velocity when the water surfaces on the downstream embankment at point D. The...

Which of the following items might be considered alimony for a divorce executed prior to 2 0 1 9 ? Payments made for the 1 2 month period after the death of the recipient spouse

Questions Q1. Write a Python program to retrieve the first and last colors from the following list: color_list = ["red", "green", "white", "blue", "black") Q2. Given the following dictionary,...