The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | Apr 2017 |
| Last Sign in: | 103 Weeks Ago, 3 Days Ago |
| Questions Answered: | 4870 |
| Tutorials Posted: | 4863 |
MBA IT, Mater in Science and Technology
Devry
Jul-1996 - Jul-2000
Professor
Devry University
Mar-2010 - Oct-2016
1. Based on the ERD in the handout, create a relational schema and write it in Word.
 2. Based on the relational schema, create tables and relationships in MS Access.
3. Solve normalizaiton problems in the handout.Â
Â
BCIS 4610, Fall 2016HW #5Part 1. ERD to relational DB model.A. Translate the ER diagram below into a relational DB model.Show the relational tables in the following format:TABLE_NAME (Attr1_PK, Attr2, …, AttrN,Attr_FK1,Attr_FK2)B. Based on your solution in section A, create tables and relationships in MSAccess. You will need to make appropriate decisions about data types. Youwill need to submit your Access Files as a part of the assignment.BCIS 4610 – HW5
Attachments:
-----------