A T Still University Database Project Tables and Their Attributes ER Diagram

User Generated

pynfflpuvpfgber

Computer Science

A T Still University

Description

Create and submit an ER Diagram with at least two tables and their attributes. Your diagram should include:

  • Table Names (for each entity)
  • Attributes (first name, last name, city, etc.)
  • Primary Keys
  • Foreign keys
  • Relationships
  • Field types (text, currency, numeric, date)

Your tables should be should be normalized (first, second and third normal forms)

You can use the attached form or upload your tables in Excel or create and link them in an Access database file.

For information on how to use Word to create and ERD, go to: https://vimeo.com/18244802

You can upload your tables in Excel, Word or create and link them in an Access database file. If you use another tool please create a PDF file of the results.

Resources for Building ER Diagrams and Normalization:

What is an ER Diagram: http://databases.about.com/od/specificproducts/l/blentity-relationship-diagrams.htm

Video Tutorial Entity Relationship Diagram (ERD) Training Video: https://www.youtube.com/watch?v=-fQ-bRllhXc

Video: How do I normalize a database: https://www.youtube.com/watch?v=xoTyrdT9SZIcle

Article: https://support.microsoft.com/en-us/help/283878/description-of-the-database-normalization-basics


Unformatted Attachment Preview

DEPARTMENTS DEPARTMENT_ID DEPARTMENT_NAME MANAGER_ID LOCATION_ID number(4) PK varchar2(30) number(6) number(4) N FK LOCATIONS LOCATION_ID number(4) PK LOCATION_NAME varchar(50) STREET_ADDRESS varchar(40) N POSTAL CODE varchar2(12) N CITY varchar2(30) STATE_PROVINCE varchar2(25) N COUNTRY_ABBRV char(2) N FK COUNTRIES COUNTRY_ABBRV char(2) PK COUNTRY NAME varchar(40) O REGION_ID number N FK N FKP REGIONS REGION_ID number PK REGION NAME varchar2(25) EMPLOYEES EMPLOYEE_ID number(6) PK FIRST_NAME varchar2(20) N LAST_NAME varchar2(25) EMAIL varchar2(25) PHONE_NUMBER varchar2(20) N HIRE_DATE date JOB_ID varchar2(10) FK SALARY number(8,2) N COMMISSION_PCT number(2,2) N MANAGER_ID number(6) N FK DEPARTMENT_ID number(4) NFK + JOB_HISTORY EMPLOYEE_ID number(6) PK FK DEPARTMENT_ID number(4) PKFK JOB_ID varchar2(10) PK FK START_DATE date PK END_DATE date JOBS H JOB_ID varchar(10) PK JOB_TITLE varchar2(35) MIN_SALARY number(6) N MAX_SALARY number(6) N created with Vertabelo
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

View attached explanation and answer. Let me know if you have any question...


Anonymous
Great study resource, helped me a lot.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags