Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a database model using ER diagram tool in MySQL for a social media platform like Facebook. Satisfy following conditions: Your model must contain at

Create a database model using ER diagram tool in MySQL for a social media platform like Facebook. Satisfy following conditions: Your model must contain at least 5 tables. Your model must contain at least 1 one-to-many relationship. Your model must contain at least 1 many-to-many relationship.

...........ERD format example.......................................................................................................................................

image text in transcribed

.................................................................................................................................................................................

LINE INVOICE PK INV NUMBER - contains FK1 CUS_CODE INV_DATE +4PK CUSTOMER PK CUS CODE tit generates CUS_LNAME CUS_FNAME CUS_INITIAL CUS_AREACODE CUS PHONE CUS_BALANCE PK,FK1 INV NUMBER LINE NUMBER FK2 P_CODE LINE_UNITS LINE_PRICE is found in VENDOR PK V_CODE PRODUCT PK P_CODE Ht - Supplies V_NAME V_CONTACT V_AREACODE V PHONE V STATE V ORDER P_DESCRIPT P_INDATE P QOH P MIN P_PRICE P_DISCOUNT V_CODE FK1

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intelligent Information And Database Systems Asian Conference Aciids 2012 Kaohsiung Taiwan March 2012 Proceedings Part 2 Lnai 7197

Authors: Jeng-Shyang Pan ,Shyi-Ming Chen ,Ngoc-Thanh Nguyen

2012th Edition

3642284892, 978-3642284892

More Books

Students also viewed these Databases questions