Erd For Clinic

This designation is worth 10 marks. Using the byplay outcome (next page), you need to contend the pursuance requirements: 1. Indentify all entities that you would need to give chase data about for the business case (people, places, things, or events) and arguing them. 2. Could you role a spreadsheet to keep track of this data? What would be the advantages and disadvantages of doing so? 3. Using Microsoft VISIO or either other draft copy software, draw the ERD (attributes, entities, relationships and cardinalities (e.g. one--?to--?one, one--?to--?many) of the database routined to support the operations of the business expound in the case. 3.a Produce the conceptual ERD with the instinctive relationships amid the entities (1:1; 1:N; N:M) providing an achievement verb that represents the relationship between the entities. For each relationship shown in your model, ply two paths to excuse the relationship from entity A to entity B and in the second line explain the relationship from entity B to entity A. (A and B are use as explanation unless. You exit use the names that you will assign to your entities. 1. A department may have set or many employees 2. An employee is employed by one and only one department 3.

b Convert your model to a Logical ERD (1:1; 1:N) that is fully attributed and contains the entries to primary keys and unsuitable keys as well. (Note: The record calls logical data model to an ERD with attributes, the mass uses the crow foot notation for this). 4. Create the data mental lexicon for your complete data model (see Excel template in the assignment folder). 5. Write 2 queries (requests) (in SQL or plain English) that a manager could answer using! this database. Your queries must each intimate the use of at least three tables. 6. If you were to implement a physical database, tell the DMBS technology that you would use to implement the database. gratify justify your selection. plagiarize the links used in your look into You must hand in: An electronic...If you want to get a full essay, order it on our website: OrderEssay.net

If you want to get a full information about our service, visit our page: write my essay