Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

An investment company wants to create a database system to manage its data. The company manage several projects. There are several investors. The investor can

An investment company wants to create a database system to manage its data. The company manage several projects. There are several investors. The investor can invest in several projects. A project can have several investors, so that a percentage of each investor is specified in each project. The project has a name, type, start date, duration and director.

You are required to:

  • Construct an ERD for the investment company database. The ERD must show the cardinality ratio.
  • Identify the attributes you need to create the company database and show them using the ERD.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

SQL Instant Reference

Authors: Gruber, Martin Gruber

2nd Edition

0782125395, 9780782125399

Students also viewed these Databases questions

Question

5. Arranging for the training facility and room.

Answered: 1 week ago