Database代写:CS326 Online Graduate Application



For Homework 1, you will create an Entity Relationship Diagram (ERD) for the online Graduate Application (details included below). Be sure to include the following:

  1. Draw an Entity Relationship Diagram (ERD).
    • Entity names must follow naming guidelines.
    • The ERD must be normalized to 3NF.
  2. Include both ordinality (i.e. required or optional) and cardinality (i.e. 1:1, 1:M, M:N, etc).
  3. Include the relationship narratives between the entities.
  4. Identify primary keys for each entity and include all appropriate foreign keys.
  5. Use Visio to complete the drawing.

Page 1: New Application

What type of Student are you?

  • Graduate
  • Graduate Non-Matriculated
  • Graduate Readmission Which College are you applying to?
  • College of Science and Engineering
  • Albers School of Business
  • College of Arts and Sciences
  • College of Education
  • College of Nursing
  • School of Theology and Ministry What type of degree are you applying for?
  • Certificates
  • Master’s

Please select the Major you are apply to?

  • Certificate in Computer Science Fundamentals
  • Certificate in Software Architecture and Design
  • Certificate in Software Project Management Term
  • Summer or Fall (and the quarter, i.e. 2016, 2017)

Page 2: Personal Information

  • Name
  • Preferred
  • Name Date of
  • Birth Mailing
  • Address
  • Preferred Phone number

Are you a US Citizen?

  • Yes
  • No

Is English your native Language?

  • Yes
  • No Gender?
  • Male
  • Female

Please tell us your veteran status

  • Not a veteran
  • Currently serving
  • Previously served
  • Current dependent Military Branch
  • Army
  • Marine Corp
  • Navy
  • Air Force
  • Coast Guard

Are you Hispanic/Latino origin?

  • Yes
  • No

Please mark all that apply:

  • Asian
  • Black/African American
  • Native Hawaiian/Pacific Islander
  • Native American/Native Indian
  • White/Middle Eastern

Page 3: Application Information

Will you be applying for financial aid?

  • Yes
  • No

Do you have employer tuition assistance?

  • Yes
  • No

Are you also applying to other programs?

  • Yes
  • No

Have you ever been convicted of a felony or a gross misdemeanor?

  • Yes
  • No

A conviction will not necessarily bar admission but will require additional documentation prior to a decision. You will be contacted shortly via email with instructions on reporting the nature of your conviction.

Have you ever been placed on probation, suspended from, dismissed from or otherwise sanctioned by (for any period of time) any higher education institution?

  • Yes
  • No

Page 4: Educational History

  • Institution
  • Attended from/to (month and year) Degree Earned
  • Major
  • Degree received date

(Note: Applicant may add multiple degrees)

Page 5: Employment History

  • Employer/Organization
  • Are you currently employed at this organization? Organization address
  • Organization phone Job title
  • Start/end date (month and year) Part-time or Full-time

(Note: Applicant may add multiple employers)

Page 6: Entrance Tests

Test Type

  • GMAT
  • GRE General
  • MAT
  • WEST-B
  • WEST-E
  • Test Date (month and year)