Assignment2 - Abdulaziz Alali 15589955 E-R Diagram for...

Info iconThis preview shows pages 1–10. Sign up to view the full content.

View Full Document Right Arrow Icon
Abdulaziz Alali 15589955 E-R Diagram for Bundooraville Following is the ER Diagram drawn for the DFD done in Assignment No.1
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Abdulaziz Alali 15589955 Cardinality Relationships among entities
Background image of page 2
Abdulaziz Alali 15589955 Tables in 3rd Normal Form Table: Student Field Type Length Constraint Student-ID Numeric Integer No null Name Text 35 Not null Parent-ID Numeric Integer Not null Address Text 50 Not null Table: Parents Field Type Length Constraint Parent-Id Auto number Integer Not null Name text 35 Not null Table: BUNDOORAVILLA Field Type Length Constraint Name Text 50 Not null Address text 100 Null
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Abdulaziz Alali 15589955 Table: Accounts Field Type Length Constraint Account-Id Auto number Integer Not null Student-Id Auto number Integer Not null Type Text 20 Not null Amount Integer Integer Not null Table : Invoice Field Type Length Constraint Invoice-Id Auto number Integer Not null Date date 6 short Not null Detail text 35 Null Amount Integer Integer Not null
Background image of page 4
Abdulaziz Alali 15589955 System Design Phase – User Interface Design Design for the new system, including a user interface, inputs, and outputs is as under. Login form
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Abdulaziz Alali 15589955 Main menu Payment Choice
Background image of page 6
Abdulaziz Alali 15589955 Input Screen
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Abdulaziz Alali 15589955
Background image of page 8
Abdulaziz Alali 15589955 Report
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 10
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 11/22/2009 for the course CSE 1is taught by Professor Eric during the Three '09 term at La Trobe University.

Page1 / 15

Assignment2 - Abdulaziz Alali 15589955 E-R Diagram for...

This preview shows document pages 1 - 10. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online