Database project. Questions to ask yourself to get started

Oct 17th, 2014
SKTFaker
Category:
Computer Science
Price: $20 USD

Question description

Questions to ask yourself to get started:

  1. What is the purpose of your db?
  2. What are the unique categories/tables/entities in your db?
  3. What fields/attributes does each table have?
  4. What are your key fields (primary & foreign)?

Create a Relational Database Logical Design to include:

ERD 
Data Dictionary 
Normalization (Justification as to how duplication was avoided),

ERD:

Use any tool that you want for the ERD, but insert a .jpg (or equivalent file type) into your final document.  One tool you might choose to use can be found in the “ER Diagram Templates” section at: http://creately.com/blog/diagrams/er-diagrams-tutorial/ . Another option that provides the ability to save your file as a jpg/gif and to use the Crow’s Foot Notation is: http://www.edrawsoft.com/entity-relationship-diagrams.php. In the reference section at the bottom of this document, other ERD tools and references are provided.

In your ERD, show entities, attributes, foreign key/primary key, relationships and cardinality.  If any item needs further clarification, do this below the ERD. 

Entities: Show entities in a rectangle.  You must show >=3 entities.

Cardinality: use Crow’s Foot notation: http://www2.cs.uregina.ca/~bernatja/crowsfoot.html

Attributes: the cs.uregina site shows the attributes inside the entities.  You can use this method, or show attributes in ovals as the creately.com site shows.  You must have at least 3 attributes per entity

Foreign Key/Primary Key: below your ERD, provide a key to explain how you are notating foreign and primary keys. 

Relationships: again, the two references show relationships differently.  You may use either method. You must create >=2 relationships

Other: Remember, if any item in your ERD needs further clarification, do this below your diagram.  Please provide a brief summary of what your ERD topic is and explain it to me like you did in class. 

Data Dictionary

For each table provide table name, attribute name, contents, data type (use either notation: auto number/number/date/text or char/varchar/date/number), required (Y/N), Primary Key/Foreign Key, Foreign Key Referenced Table, specifics about the data


Normalization:

  Write at least two paragraphs to justify how duplication was avoided. 


I wanna my project to be about  Pharmacy.  


Employee, Customer, Physician, Customer has prescription, Prescription. 

Tutor Answer

(Top Tutor) Daniel C.
(997)
School: UC Berkeley
PREMIUM TUTOR

Studypool has helped 1,244,100 students

7 Reviews


Summary
Quality
Communication
On Time
Value
kpcutie
Dec 6th, 2016
" Excellent job "
Hemapathy
Nov 22nd, 2016
" all I can say is wow very fast work, great work thanks "
BlueOcean
Nov 9th, 2016
" Awesome! Exactly what I wanted. "
kevin12622
Oct 31st, 2016
" Goes above and beyond expectations ! "
ashleyisgod
Oct 17th, 2016
" Top quality work from this guy! I'll be back! "
likeplum4
Oct 8th, 2016
" Excellent work as usual "
Molly_Moon
Sep 25th, 2016
" AMAZING as always! "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1820 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors