Skip to content

Questions to ask yourselfto get started1&nbsp What is the purp

    Questions to ask yourselfto 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 DatabaseLogical Design to include:ERD Data Dictionary Normalization(Justification as to how duplication was avoided),ERD:Use any tool that you wantfor the ERD, but insert a .jpg (or equivalent file type) into your finaldocument.  One tool you might choose to use can be found in the “ERDiagram Templates” section at: http://creately.com/blog/diagrams/er-diagrams-tutorial/ . Anotheroption that provides the ability to save your file as a jpg/gif and to use theCrow’s Foot Notation is: http://www.edrawsoft.com/entity-relationship-diagrams.php. Inthe reference section at the bottom of this document, other ERD tools andreferences are provided.In your ERD, showentities, attributes, foreign key/primary key, relationships andcardinality.  If any item needs further clarification, do this below theERD. Entities: Show entities in a rectangle.  You must show >=3entities.Cardinality: use Crow’s Foot notation: http://www2.cs.uregina.ca/~bernatja/crowsfoot.htmlAttributes: the cs.uregina site shows the attributes inside the entities. You can use this method, or show attributes in ovals as the creately.com siteshows.  You must have at least 3 attributes per entityForeign Key/Primary Key: below your ERD, provide a key to explain how you are notatingforeign and primary keys. Relationships: again, the two references show relationships differently. You may use either method. You must create >=2 relationshipsOther: Remember, if any item in your ERD needs further clarification,do this below your diagram.  Please provide a brief summary of what yourERD topic is and explain it to me like you did in class. Data Dictionary: For each table providetable name, attribute name, contents, data type (use either notation: autonumber/number/date/text or char/varchar/date/number), required (Y/N), PrimaryKey/Foreign Key, Foreign Key Referenced Table, specifics about the dataNormalization:  Write at least twoparagraphs to justify how duplication was avoided. I wanna my project to be about Pharmacy.  The Entities: Employee, Customer,Physician, Customer has prescription, Prescription.

    You can hire someone to answer this question! Yes, assignist.com has paper writers, dedicated to completing research and summaries, critical thinking tasks, essays, coursework, and other homework tasks. Its fast and safe.

    >>>ORDER NOW SECURELY–HIRE A PAPER WRITER<<<