Create a database design with the following rules. List down all the entities and attributes and...

Create a database design with the following rules. List down all the entities and attributes and draw out the relationships. List all the business rules.

1. A person can have multiple accounts (Track individual accounts, Trusts, IRA, 401k, HSA, etc)

a. Not all accounts must be through brokerage

2. Multiple brokerages (Fidelity, Vanguard, ect)

a. Multiple accounts with different brokerages

b. Multiple types of accounts allowed at each broker

3. Categorization of investments (Large Cap, mid cap, small cap, Bonds , international, ect)

a. Should be able to know which category each account is with

Expert Solution

Database Design
Define Accounts

--------
account_id | account_type
---------------------------
001 | Trusts
002 | IRA|
003 | 401k
004 | HSA
===========================

Define Brokerages
---------
brokerage_id| brokerage_name
----------------------------
001 | Fidelity
002 | Vanguard
===========================

Link all features to one unique entity which is user(account_no)-> has account type, joint for xyz investment, has abc brokerage
user_accounts
-------------
account_no(Null Not allowed) | account_id(Null Not allowed) | investment_id(Null allowed) | brokerage(Not Allowed)
--------------------------------------------------------
1245 | 001 | 002 | 002

It means account 1245 is of type Trusts joint with investment mid cap has brokerage Vanguard

venereology answered 1 year ago

Database Question Create two entities for Online Journalists business. Each entity must have 5 attributes and...

Database Question Create two entities for Online Journalists business. Each entity must have 5 attributes and explain the type of each attribute.

List a few entities, attributes, activities, events, and state variables for the following processes: a. Checkout...

List a few entities, attributes, activities, events, and state variables for the following processes: a. Checkout process at a grocery store b. Admission process at hospital c. Insurance claim process

Create a Database in POSTGRESQL using the following table names and attributes: users: userid (int, primary...

Create a Database in POSTGRESQL using the following table names and attributes: users: userid (int, primary key), name (text) movies: movieid (integer, primary key), title (text) taginfo: tagid (int, primary key), content (text) genres: genreid (integer, primary key), name (text) ratings: userid (int, foreign key), movieid (int, foreign key), rating (numeric), timestamp (bigint, seconds since midnight Coordinated Universal Time (UTC) of January 1, 1970) tags: userid (int, foreign key), movieid (int, foreign key), tagid (int, foreign key), timestamp (bigint, seconds...

Why business rules are important for a good database design? Give 3 examples of business rules...

Why business rules are important for a good database design? Give 3 examples of business rules in academic environment.

Which of the following best illustrates the relationship between entities and attributes?

Which of the following best illustrates the relationship between entities and attributes? A. The entity CUSTOMER with the attribute ADDRESS B. The entity PRODUCT with the attribute CUSTOMER C. The entity CUSTOMER with the attribute PRODUCT D. The entity ADDRESS with the attribute CUSTOMER E. The entity PRODUCT with the attribute PURCHASE

Create a Database from blank (scratch) for a manager and name it. Create and design a...

Create a Database from blank (scratch) for a manager and name it. Create and design a table and name it. For each fields click and choose proper a data type such as short text and name the field. Make at least three fields. Enter your records. Make sure to add your name as a record. Similarly create two more tables. By design tool, make a relationship between each of two tables at a time and drag a primary key one...

Flag Create a database for PAINTER and PAINTING entities/tables; Decide on your own what will be...

Flag Create a database for PAINTER and PAINTING entities/tables; Decide on your own what will be the attributes of PAINTER and PAINTING tables; Insert at least 5 records on each table Deliverables: Screenshot of PAINTER and PAINTING table structures using the describe command Screenshot of PAINTER and PAINTING table records/entries using select command.

1- How do business owners create legal entities? Is the process the same for all entities?...

1- How do business owners create legal entities? Is the process the same for all entities? If not, what are the differences? 2- What is an operating agreement for an LLC? Are operating agreements required for limited liability companies? If not, why might it be important to have one? 3- How do corporations protect shareholders from liability? If you formed a small corporation, would you be able to avoid repaying a bank loan from your community bank if the corporation...

Create first draft for online shopping database (SQL): Things to do: Identify the entities Identify the...

Create first draft for online shopping database (SQL): Things to do: Identify the entities Identify the attributes Constraints Relations First Normal form Second Normal Form Third Normal Form Test Query to: Add a new item as a seller Query for total number of sold item in past month Query for total income in US DOLLARS

In this forum, discuss business rules and how they influence database design. Explain what is data...

In this forum, discuss business rules and how they influence database design. Explain what is data modeling and why data models are important. Submission Format: Initial post must be made 2 or more days before the closing date, 5 or more sentences long, must be the correct response as well as thoughtful.

Question