ahmed salah

ahmed salah

  • NA
  • 530
  • 149.8k

Are this design (ERD) is correct for the following table

Nov 4 2016 11:14 AM

I have table for instructor in university .

 

 
This center give courses for programming language specialized to Microsoft product
 
 

this interface as following in image

 
 
http://www.mediafire.com/view/113377hcz2cxrj9/Instructor_table.jpg
 
 
 

SQL,c#,access,c++ courses that given by center

 
 

D(4),G(2),G(5),G(6),G(3) is sections

 
 

B.A ,I.S is departments of year in university

 
 

university consist from 4 year as following department as (INFORMATION SYSTEM

 
(I.S) OR
 
 
BUSINESS ADMIN(B.A)OR TRADE ENGLISH (T.E)
 
 

I make ERD design as following :

 
 

this erd for interface above

 
 

Can you tell me are this design is true for table above

 
 
http://www.mediafire.com/view/2anhnki51b3b618/Diagram.jpg