DATABASE DESIGN AND Sample Clauses

DATABASE DESIGN AND. IMPLEMENTATION The large amount of complex data collected for analysis required a well-designed and organized database. The database design in this study followed the Entity/Relationship (E/R) diagram approach. A detailed introduction of the E/R diagram approach is available in the report by Xxxxxx-Xxxxxx et al. (2002). Figure 4-1 shows the E/R diagram of the database. GPS Position N GPS Position W Day Time Trip Block Trip No. TSP trip TSP route TSP block Schedule at bus stop Speed Heading Schedule at intersection Bus Location Related HDOP Bus Assignment Intersection ID Satellites Related Incident delay Related Actual run time Bus Operation Intersection ID TSP Calling Scheduled Run time Late time Trip No. Detected time Priority request Results to request Trip No. Day No. of Stops No. of lifts Operator experience Figure 4-1 E/R Diagram of Database According to Figure 4-1, the following database objects are needed: Entities: • Bus location • Bus assignment information • Bus operation information • TSP calling Relationships: • Belong to: binary, many-one • Related to: binary, many-one Relational schemas: • Bus location (Trip block, Time [hhmmss], Day [mmddyy], GPS coordination N, GPS coordination W, Speed, Heading, HDOP, Satellites) • Bus Assignment Information (Trip No., TSP trip, Route No., Trip block, schedule at each time-point on weekday/ Saturday/ Sunday and holiday, schedule at each intersection with TSP sensor on weekday/ Saturday/ Sunday and holiday, Intersection ID) • Bus Operation Information (Trip No., Day, No. of stops at bus stops, No. of wheel chair/bicycle lifts, operator experience [year], late time at the first bus stop [second], scheduled running time [second], actual running time [second], incident delay [second]) • TSP Calls (Intersection ID, coordination N, coordination W, Trip No., Bus detected time, Day, Priority request made, Results to request) Foreign Keys: • (Buslocation.Tripblock, Buslocation.Time, Xxxxxxxxxxx.Xxx) references BusAssignmentInformation.TripNo. • (BusOperationInformation.TripNo, XxxXxxxxxxxxXxxxxxxxxxx.Xxx) references BusAssignmentInformation.TripNo. • (TSPCalls.IntersectionID) references BusAssignmentInformation.TripNo.. In this study, we used the Structured Query Language (SQL) for data management. This database was implemented in the Microsoft SQL Server 2000.
AutoNDA by SimpleDocs

Related to DATABASE DESIGN AND

  • Design and Non-Design 109.20.3.1 Trip Charge - Premises Visit Charge No USOC $95.00

  • Web Hosting If Customer submits a Service Order(s) for web hosting services, the following terms shall also apply:

  • Technology Upgrades Notwithstanding any other provision of this Agreement, Verizon shall have the right to deploy, upgrade, migrate and maintain its network at its discretion. The Parties acknowledge that Verizon, at its election, may deploy fiber throughout its network and that such fiber deployment may inhibit or facilitate PNG’s ability to provide service using certain technologies. Nothing in this Agreement shall limit Verizon's ability to modify its network through the incorporation of new equipment or software or otherwise. PNG shall be solely responsible for the cost and activities associated with accommodating such changes in its own network.

  • Schematic Design Phase Services § 3.2.1 The Architect shall review the program and other information furnished by the Owner, and shall review laws, codes, and regulations applicable to the Architect’s services.

  • Research Design The data generated by excavations at the prehistoric site(s) will be used to examine at least three topics: (1) chronology; (2) technology; and (3) subsistence practices. Insights into changing patterns of community organization may also be granted, as may insights into changes in social organization. The data recovered will then be compared to data from other regional sites.

  • XXX Hosting 10.1 XXX Hosting is not required for resale in the BellSouth region.

  • Technology Access A. Contractor expressly acknowledges that state funds may not be expended in connection with the purchase of an automated information system unless that system meets certain statutory requirements relating to accessibility by persons with visual impairments. Accordingly, Contractor represents and warrants to System Agency that the technology provided to System Agency for purchase (if applicable under this Contract or any related Solicitation) is capable, either by virtue of features included within the technology or because it is readily adaptable by use with other technology, of:

  • Project Design Applicants must design a project that provides access to health services to enable eligible women and men experiencing health needs to secure and maintain safe and accessible quality screening and diagnostic services, comprehensive family planning, and/ or other women’s health services.

  • Technical Support Services 2.1 The technical support services (the "Services"): Party A agrees to provide to Party B the relevant services requested by Party B, which are specified in Exhibit 1 attached hereto ("Exhibit 1").

  • Design Development Phase Services 3.3.1 Based on the Owner’s approval of the Schematic Design Documents, and on the Owner’s authorization of any adjustments in the Project requirements and the budget for the Cost of the Work, the Architect shall prepare Design Development Documents for the Owner’s approval. The Design Development Documents shall illustrate and describe the development of the approved Schematic Design Documents and shall consist of drawings and other documents including plans, sections, elevations, typical construction details, and diagrammatic layouts of building systems to fix and describe the size and character of the Project as to architectural, structural, mechanical and electrical systems, and other appropriate elements. The Design Development Documents shall also include outline specifications that identify major materials and systems and establish, in general, their quality levels.

Time is Money Join Law Insider Premium to draft better contracts faster.