Database Project Specs

Database Project Specs

Purpose: To gain exposure to relational database by creating a logical design (documentation of planning the design) and a physical design (actual implementation into MS Access) of an approved topic for a database.

Grading: project grading sheet can be found in the “content” area in Blackboard.

Framework: A framework for how your project should be submitted is attached.

Part A: Database Topic Selection

You may not choose any of the database topics shown in the examples from  the reference section or used in class. 

Part B: Logical DesignSubmit ­one Word document via Blackboard -> Assignments -> Logical Database Submission.

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. 

Part C: Physical Design
Due: 11/9/14

Submit ­one Microsoft Access document via Blackboard -> Assignments -> Physical Database Submission. Also, please resubmit the same (or revised) ERD document that you submitted for your logical design.  (two files should be submitted total) In your submission notes, indicate if you created any extra credit reports or forms and what they are named.

Implement the graded logical design (with improvements) into a physical design in MS Access.  Before implementing in Access, any issues from grading of the logical DB must be addressed, either through further contact with the professor (if this was stated in your grading document) or in your Access database.

  1. For each implemented table:
    1. ensure that you have defined the Field Name, Data Type and provide a good description.  If an input mask is applicable, make sure to put this in.
    2. you must have several data rows created (aim for >=10 rows per table, unless this doesn’t make sense for one of your tables)
    3. designate a primary key.  In your description, indicate if a field will be a foreign key (FK)
  2. Make sure you have defined the database relationship(s) in Access. Make sure that you have specified the correct join type (hint: you don’t want redundant data. Join is most likely the default join unless you are doing something more advanced.)
  3. Create at least one query
  4. Create at least one lookup column
  5. Forms or report can be created for extra credit points if desired (max of 5 points possible).

References:

I already finished the first part ( Part A), the Database Topic. i choose Pharmacy and the entities are Employee, Customer, Physician, Customer has prescription, Prescription.

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more
error: Content is protected !!