System Design & Development

MIS

This is an ERD for a company with the following details: 1. Company organized into DEPARTMENT. Each department has unique name…

Examination Scheduling

Consider a university database for the scheduling of classrooms for final exams. This database could be modeled as the single entity…

Online Bookstore

This is an ER diagram example that shows the major business entities of an online bookstore as well as their…

Favorited Team Statistics

This E-R diagram example keeps track of the exploits of your favorited sports team. The database design stores the matches played,…

Student Score

Here are two versions of an ERD for marks database. a) Consider a database used to record the marks that…

Hospital

This is an E-R diagram (ERD) example for a hospital with a set of patients and a set of medical doctors.…

Car Insurance

This is an E-R diagram example for a car-insurance company whose customers own one or more cars each. Each car has…

University Registration Office

This ERD example models the following information. 1. A Course has an ID (for unique identification), syllabus, title, credits and…

Hockey League

Suppose you are given the following requirements for a simple database for the National Hockey League (NHL): The NHL has many…

Prepare Project Proposal

Here is a PERT chart example that shows the tasks in within a system analysis and design life cycle. Suppose…