Information Systems Project (Coursework Sample)

Milestone 3: Logical Design Document and Diagrams (Part I) In this logical design, the functional requirements have been broken down to use cases as shown below. Alongside each use case, there are a set of narratives that are used to support the use cases therein. Logical design document and diagrams: Use case diagrams:255270025463500 locomotive 336466139929schedule00schedule 1082650600970015303525019000Locomotive 4110355232410route00route34745937200900 10820401428750035814024511000 -18288025044400 111922665176001119226651760010826501397000356981813970004272280247650departure00departure -73152621335844526187 354584019748500 419752849937Arrival date00Arrival date 34820351666200411038065253Crew(s)00Crew(s) A railroad will often have a set of railroad freight cars. These are going to be attached to either one locomotives or even a number of them. These are going to have specific schedule, route, departure and the arrival date. More still, it can have one or more crews in it. The process of scheduling is controlled from a central location which is the operations department. This work is done by the scheduling clerks. Use case diagram 2 for Master Schedule(database table) 3789274239014Train number00Train number 102412814884500 3087014168250003006090-4027680022677120482600 102412811480800372341256388Location of origin00Location of origin 31889701841500050474911958300 102412811734800102412815392400987552153924003788410153670Location of destination00Location of destination731521537720 3093720180340001168402463800050474924648200 409481088849Time of departure00Time of departure 300654721244600 372239592939Expected time of arrival00Expected time of arrival The master schedule is a database table that contains all the information regarding the scheduling operations that are done in order to meet the customers' demands. It contains the following functional elements, the location of origin, the train number, location of destination, and time of departure and the expected time of arrival. This helps in making all the scheduling operations to be efficient. Use case 3: Route assignment -79710385141Route assignment00Route assignment3335655143510Starting point00Starting point263334512890500 753110148590005852214884400 3335020196850Ending point00Ending point263347119766300 248285342900075311023876000 75311038735007534663195300-160934319530 329153529744Way points/connections00Way points/connections25602951478300 -39560585090002482858509000 3130754244196Identification code00Identification code244983013398500 This need for assigning the routes is needed because there are many different routes a train can use to get from point of origination to point of destination. A route often consists of a starting point, and ending point and a series of intermediate way points or connections. The route is identified by unique 6 character identification code which is used to identify the route. The assigning of route is done in a route assignment table while all the intermediate routes are ignored in the database. Use case 4: locomotive assignment 2889505185420003789274243942Date of manufacture00Date of manufacture 8119871684020077541162926000775411123642100775411142661600775411142661...