TABLE OF CONTENTS
Week 2 Lab: Entity Relationship Diagram
In this Lab, you will create an entity relationship diagram for a restaurant review website.
The major entities involved in this database design are the following.
Restaurant – the eating establishment being reviewed
Administrator – a person authorized to enter and update information about a restaurant such as name, address, hours of operation, etc.
Reviewer – a person who write reviews of restaurants
Review – the review of a restaurant
These are the business rules that apply to these entities.
Each Restaurant can be administrated by one or many Administrators; each Administrator can administer one or many Restaurants.
Each Review is for one and only one Restaurant; each Restaurant can have zero or many Reviews.
Each Review is written by one and only one Reviewer; each Reviewer can write zero or many Reviews.
A table provided in the lab instructions gives detailed information about the attributes that must be stored for each entity.
After completing the steps below, submit a single Microsoft Word document file named LabWeek2xxx.docx (where xxx = your initials). This file will contain two Entity Relationship Diagrams (ERDs) copied and pasted from Microsoft Visio:
Conceptual: A conceptual data model diagram of this database showing:
the four major entities
the relationships among the entities
Logical: A logical data model diagram of this database showing:
all entities (including any needed associative entities)
the relationships among the entities
all primary and foreign keys
attributes for each entity
a data type for each attribute
Conceptual data model diagram includes all entities with correct entity names and all required relationships with correct cardinalities indicated via crow’s foot notation.
Logical data model diagram includes the same entities and relationships as shown on the conceptual data model and correctly resolves the many-to-many relationship using an appropriate associative entity.
Logical data model includes all required attributes for each entity with appropriate data types, correctly designates all primary and foreign keys, and uses a visually organized and readable layout.
A quality assignment will fulfill all criteria
Access the software through the Azure Virtual Lab Environment at http://labs.azure.comLinks to an external site. or download and install a personal copy from the Student Software Store. The link to the Student Software Store is on the Course Resources Page in the Introduction and Resources Module.
The lab instructions and videos were created using Microsoft Visio 2019. Any recent version of Visio will work similarly, but some adjustments to instructions may be needed.
NOTE: Microsoft does not provide a MacOS version of Visio. Mac users should access Visio through the Citrix Virtual Lab environment.
Microsoft Office: Word
Access the software through the Azure Virtual Lab Environment at http://labs.azure.com or download and install a personal copy from your student Office365 account, accessed through the student portal.
Sortmyessay.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we\’ll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Why Hire Sortmyessay.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
SortMyEssay.com is an online academic writing platform that provides customers with high-quality papers, regardless of their academic level or the country they come from. Founded in 2012, SortMyEssay.com has quickly become one of the leading providers of quality academic writing services across the globe. It is well known for its exceptional customer service and its dedication to providing only top-notch content to its customers.
At SortMyEssay.com, we understand that not all students are on the same academic level – some may be just starting out, while others may have already completed a number of degrees in various disciplines – so our team strives to provide essays that meet each student’s individual needs. Our writers have been specially trained to write according to different levels of students and also customize each essay according to the client’s specific requirements and instructions given by their professor/teacher/lecturer etc., thus ensuring accuracy and quality at all times.
When it comes to undergraduate (UG) essays, our writers focus on topics such as Accounting, Biology, Computer Science, Economics, English Literature and Language Arts among many others; Masters’ (MA) essays usually require profound knowledge about a particular subject matter or topic with respect to which our experts are well versed; Doctoral (PhD) essays call for original research work based on primary sources; Postgraduate (PG certificate/diploma) essays are more focused on extensive secondary source review focusing on areas such as Business Administration or Human Resource Management; And finally Professional Certification courses requires up-to-date knowledge about current developments & trends within a particular field like Project Management or Quality Assurance etc.. Such broad range allows us to accommodate almost any request made by our esteemed customers who can rest assured knowing their essay will be written perfectly tailored towards their current educational goals & aspirations!
Our commitment towards excellence doesn’t stop at just meeting your individual needs but extends even further when it comes countries served – SortMyEssay covers nearly every country around the world including USA , UK , Canada , Australia , Germany , France among other countries making sure there’s nothing stopping you from achieving success! Our staff consists of professional writers committed towards delivering top notch content while keeping prices affordable enough so everyone can benefit from them no matter what part of world they live in !
Furthermore we ensure strict adherence towards deadlines set forth by clients so you don’t miss any important milestones along your way . We believe time is valuable & should not be wasted trying to figure out how produce high quality paper without breaking bank – which is exactly why we turn impossible into possible & always deliver ahead schedule !
All in all we strive hard everyday make sure none our clients ever disappointed with services provided here at sortmyessay . With expert assistance available round clock guarantees fast turnaround time helping them secure good grades . As one biggest players industry today you can rely us full confidence knowing your assignment safe hands . So go ahead contact now get started journey success !
At SortMyEssay.com, we understand that quality is the key to successful academic writing and this is why all of our papers are written by experienced professionals who have extensive knowledge in their respective fields. We also ensure that each paper goes through multiple levels of review before being delivered to the customer, which includes a rigorous plagiarism check as well as editing for grammar mistakes & typos. This guarantees that only the best-written papers make it into your hands!
Although essays are our specialty, we do not limit ourselves to just this service – our writers can assist with any type of academic writing you may require such as term papers, research papers, coursework assignments & even dissertations so don’t hesitate contact us if you need help completing more complex tasks!
We take pride in delivering quality services to all clients at an affordable price and believe that everyone deserves access to high-quality content regardless of their location or budget. Our commitment towards excellence has earned us accolades from customers around world making us one best online academic writing platforms available today !
So what are you waiting for ? Get started now and experience the power behind sortmyessay ! You won’t regret it