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
Hey! How are you? Please check the attachment and let me know if you need more information.Thank you
Â
Â
1. Download and install the ERWin data modeling tool. Include the screenshot of your installed ERWin
application. 2. Using the ERWin software, design and draw the ER diagram of the COMPANY database we talked
about last class. Include the screenshot of your whole ER diagram. 3. ERWin provides a powerful feature called forward engineering that allows the database designer to
convert the ER design into a schema generation SQL script for one or more target relational
databases. Using forward engineering, generate and show the SQL script. For more information
about forward engineering, please take a look at this video: https://www.youtube.com/watch?
v=OJ7sS2hl51c 4. Create a database called COMPANY using those generated SQL scripts in MySQL database. Show the
screenshot of your database and tables in MySQL. To manage your database, you can use the
phpmyadmin tool or MySQL Workbench. 5. Cardinality ratios often dictate the detailed design of a database. The cardinality ratio depends on
the real-world meaning of the entity types involved and is defined by the specific application. For the
binary relationships below, suggest cardinality ratios based on common-sense meaning of the entity
types. Clearly state any assumptions you make. Entity 1 Cardinality Ratio Entity 2 1. Student SocialSecurityCard 2. Student Teacher 3. ClassRoom Wall 4. Country CurrentPresident 5. Course TextBook 6. Item (that can be
found in an order) Order 7. Student Class 8. Class Instructor 9. Instructor Office 10. E-bay Auction item E-bay bid
-----------