Question: Please create two ER Diagrams for part one and two of questions, thanks! ERDPlus prefered Part 1 Create the ER diagram for the database of
Please create two ER Diagrams for part one and two of questions, thanks! ERDPlus prefered
Part
Create the ER diagram for the database of a social media company that keeps track of:
For each user: birthdate, unique userid.
For each posting: pnumbner, pcontent. Postings of different users can have the same pnumber, but postings of the same user must have a unique pnumber.
Each user posts zero or many postings. Each posting is posted by one and only one user.
Part
Investco Scout is an investment research company. Create the ER diagram for the Investco Scout Funds database, based on the following requirements.
The Investco Scout Funds Database will keep track of investment companies, their customers, the mutual funds they manage, and securities contained in the mutual funds.
For each investment company, Investco Scout will keep track of a unique investment company identifier and a unique investment company name as well as the names of multiple locations of the investment company.
For each customer, Investco Scout will keep track of a unique customer identifier as well as the customer name, address, multiple phone numbers, date of birth, and age.
For each mutual fund, Investco Scout will keep track of a unique mutual fund identifier as well as the mutual fund name and inception date.
For each security, Investco Scout will keep track of a unique security identifier as well as the security name and type.
Each investment company must manage at least one mutual fund, but can manage multiple mutual funds. A mutual fund is managed by one and only one investment company.
Each investment company can have many customers, but does not have to have any. Each customer must belong to at least one investment company, but may belong to many investment companies.
A customer can refer many other customers, but does not have to refer any. Each customer can be referred by one other customer, or may not be referred by any.
A mutual fund contains one or many securities A security can be included in many mutual funds. Investco Scout also keeps track of securities that are not included in any mutual funds.
For each instance of a security included in a mutual fund, Investco Scout keeps track of the amount included.
Note: Please ignore associative entity if any
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
