Using Visio or any other drawing software, draw the ERD (attributes, entities, relationships and cardinalities (e.g. one-to-one, one-to-many) of the database used to support the operations of the business described in the case. The ERD should identify all primary keys and foreign keys. If you decide to use Visio (2013), you can watch the video tutorial below that shows how to draw an ERD with this tool: https://www.youtube.com/watch?v=K0mNzXnHkYc&feature=youtu.be The PowerPoint for the video tutorial is available from the link below (Please notice that the tutorial for the creation of data dictionaries in only included in the video for Visio 2010): http://jmsb.concordia.ca/~rvalverde/Assignment2tutorial.pptx Please bear in mind that Visio only works on Windows. If you have a Mac, you might want to use the DIA diagram editor available from the link below: http://dia-installer.de/download/macosx.html A video that shows how to use this software to draw ERDs is available from the link below:
Sun | Mon | Tue | Wed | Thu | Fri | Sat |
---|---|---|---|---|---|---|
27 | 28 | 29 | 30 | 1 | 2 | 3 |
4 | 5 | 6 | 7 | 8 | 9 | 10 |
11 | 12 | 13 | 14 | 15 | 16 | 17 |
18 | 19 | 20 | 21 | 22 | 23 | 24 |
25 | 26 | 27 | 28 | 29 | 30 | 31 |