Making an ERD

Powerful Essays
Topics: Currency, Telephone
COIT20247: Database Design and Development
Term1, 2015
Assessment 1 - Systems Development

Lecturer: Umapathy Venugopal
Tutor: Umapathy Venugopal

Prepared by:
William Rogers
S0267955

Table of Contents

Business Rules 4
List of assumptions 4
Entity and Attribute Definitions: 5
Reference List 7

Business Rules

All staff must record their full name, address, and phone numbers as well as be given a unique employee ID.
Analysts are required to give their expertise while managers and administrative staff must give their qualifications.
Recommendations made by their research must be given with a recommendation to buy, sell, or hold, with a brief reason why.
Recommendations are time sensitive, so recommendations must come with a date and time.
Currencies are described by code, name, interest rate, and rating (i.e. S&P or Moody’s).
Managers may manage multiple portfolios.
Every portfolio has its own ID.
Portfolios can be regarded as an account and only associated to one client.
The portfolio must contain data for available cash, and data for trades for each individual portfolio.
Trade details include the amount traded, the trade mode, and the exchange rate.
There are “normally” three client types that must be recorded along with their details such as their client ID, address, and phone numbers.
Individuals must give their TFN, businesses must give their ABN, and trustees must give the trust account number.

List of assumptions

1.) I did not add a double line to the employee sub-types because I didn’t feel that three employee types would be sufficient. Most likely for this type of business there would be other employees like a secretary or IT staff.
2.) I placed a d in the circle for subtypes to indicate subtypes as discriminators. Every employee most likely has a specific position.
3.) I created an associated entity between Portfolio and Currency to resolve a many to many relationship. Inside a placed attributes that would be specific to

You May Also Find These Documents Helpful

  • Good Essays

    Dfd and Erd

    • 283 Words
    • 2 Pages

    Difference Between ERD and DFD ERD and DFD are data presentation models that help in identifying the flow of data as well as inputs and outputs. They are important as they enable effective communication between members of different departments in an organization. There are similarities in the two types of data presentation models although there are differences that will be talked about in this article. DFD’s are systematic representation of how data flows in an organization, how and from where…

    • 283 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    Erd Explanation

    • 260 Words
    • 2 Pages

    ERD Explanation DBM/380 January 23, 2012 ERD Explanation There are several levels of normalization such as 1NF, 2NF, and 3NF. The Huffman Driver database was brought to the normalization level of 3NF by following a series of guidelines from the lowest form of normalization, 1NF. The first normalization form level (1NF) consists of the basic rules for an organized database. These are: • Eliminate duplicative columns from the same table. • Create separate tables for each group…

    • 260 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Normalization of the Erd

    • 857 Words
    • 4 Pages

    Normalization of the ERD By: Vanessa Kennedy Normalization of the ERD The normalization of the ERD along with the driver’s log is taking all of the data within the database and putting the information into tables (World Book, 2011). In addition, after the data is normalized it then is put into an Entity Relationship Diagram or ERD (World Book, 2011). In this paper we will look at the ERD of the driver’s log. The normalization that I would perform on the driver’s log would be on the Driver’s…

    • 857 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Erd Diagram

    • 506 Words
    • 3 Pages

    Question 1 Given the following business rules, create the appropriate Crow’s Foot ERD. a. A company operates many departments. b. Each department employs one or more employees. c. Each of the employees may or may not have one or more dependents. d. Each employee may or may not have an employment history. Question 2 The Hudson Engineering Group (HEG) has contacted you to create a conceptual model whose application will meet the expected database requirements for the company’s…

    • 506 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Library Erd

    • 11801 Words
    • 48 Pages

    Cornell Law Library Scholarship@Cornell Law: A Digital Repository Cornell Law Faculty Working Papers Faculty Scholarship 4-10-2010 Digitizing the World 's Laws Claire M. Germain Cornell Law School, cmg13@cornell.edu Recommended Citation Germain, Claire M., "Digitizing the World 's Laws" (2010). Cornell Law Faculty Working Papers. Paper 72. http://scholarship.law.cornell.edu/clsops_papers/72 This Article is brought to you for free and open access by the Faculty Scholarship at…

    • 11801 Words
    • 48 Pages
    Powerful Essays
  • Good Essays

    Huffman Trucking ERD Explanation Alvin Calahan, Adam Morgan University of Phoenix Database Concepts DBM/380 Michael James November 19, 2011 Huffman Trucking ERD Explanation Huffman Trucking, founded in 1936 with a single tractor trailer has grown tremendously over the years. Huffman Trucking now has 800 road trailers, 2100 45 ft. trailers, 260 roll-on and roll-off units, 925 drivers, and 425 support personnel. With facilities in Cleveland, OH, Los Angeles, CA, St. Louis, MO, and Bayonne…

    • 728 Words
    • 3 Pages
    Good Essays
  • Better Essays

    Erd for Huffman Trucking

    • 1061 Words
    • 5 Pages

    Website Navigation and Developmental Plan Joe Example Website Navigation and Development Plan Website success main part is the website navigation. Various parts of the content gateway are the website navigation. If the site does not have some sort of navigation, then it will lose all sense of structure and organization. The main thing is the access of your website from anywhere which is very important part of the success. The wonderful part of the website is to go to any page by clicking just…

    • 1061 Words
    • 5 Pages
    Better Essays
  • Best Essays

    Ob/Gyn Erd

    • 3259 Words
    • 14 Pages

    JOMO KENYATTA UNIVERSITY OF AGRICULTURE AND TECHNOLOGY TAITA TAVETA CAMPUS A PROPOSAL TO IMPLEMENT A POINT OF SALE SOLUTION FOR THE MUNICIPAL COUNCIL OF VOI By Name: Reg. No.: Faculty: I.C.S.I.T. Department: Mathematics and Informatics Supervisor: Mr. Fanon Ananda, Maths and Informatics department. Date: Friday, 12/10/2012 A research proposal submitted in partial fulfilment of the requirement for the award of “Bachelor’s Degree in Information Technology”.…

    • 3259 Words
    • 14 Pages
    Best Essays
  • Good Essays

    Draw ENTITY RELATIONSHIP DIAGRAM (ERD) for the following requirement: 1. Students take courses in a college 2. Customers have accounts in a bank 3. People own vehicles 4. Employees manage projects 5. Machines are made up of parts 6. A college offers several courses. Attributes of the course include course code, name and credits. Each course may have zero or more subjects 7. Hotel (HotelNo, Name, Add, TelNo) Room (RoomNo, HotelNo, Type, Price) Booking (HotelNo…

    • 319 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    customer and a second for subscription. Specify identifiers, attributes, relationships and cardinality 2. (2 pts) Draw the ERD for the following scenario. The only attribute you need to include is the IDENTIFIER. Be careful with your cardinality. A patient has one or more patient histories; each instance of patient history belongs to one patient. 3. (2 pts) Draw the ERD for the following scenario. Include all the attributes. Note that one of your tables will have a composite identifier. You…

    • 298 Words
    • 2 Pages
    Satisfactory Essays