1 / 9

ER-Diagram

ER-Diagram. Database Project. ER-Diagram. ER Description . In the first it is simple database and may be cannot contain all types of relationships. This is a Diagram for Engineering company and do three types of tests as follow (Soil,Concrete,Steel) and sort data about each test. Cont.

philip-clements
Download Presentation

ER-Diagram

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. ER-Diagram Database Project

  2. ER-Diagram

  3. ER Description • In the first it is simple database and may be cannot contain all types of relationships. • This is a Diagram for Engineering company and do three types of tests as follow (Soil,Concrete,Steel) and sort data about each test.

  4. Cont. • Customers Entity . • It is contain a C_id and this is a primary key and c_name that represent the names of customers. • Projects Entity. • It is the same of customers Entity but represent the projects.

  5. ER-Description • The Steel, Soil And Concrete Entities. • It is contains the test_id and this is a primary key and the date of arrest of the test and the amount or price of the test.

  6. Relational • Create table Projects(p_id number(4) primary key, • P_name char(20)); • Create table Customers (c_id number(4) primary key, • C_namevarchar(20));

  7. Cont. • Create table Steel (test_id number(5) primary key , • date_of_Arrest date , Amount number(3), • c_id number(4), foreign key(c_id) references Customers(c_id) ,p_id number(4) foregin key (p_id) references Project(p_id) );

  8. Cont. • Create table Concrete((test_id number(5) primary key, • date_of_Arrest date , Amount number(3c_id number(4), foreign key(c_id) references Customers(c_id) ,p_id number(4) foregin key (p_id) references Project(p_id) );

  9. Cont. • Create table Soil(test_id number(5) primary key , • date_of_Arrest date , Amount number(3),c_id number(4), foreign key(c_id) references Customers(c_id) ,p_id number(4) foregin key (p_id) references Project(p_id) );

More Related