Patients can be admitted to the hospital. The doctor will handle patients, one doctor can Treat more than 1 patient. Hospital Management System Database ProjectĪ patient will have a unique Patient ID. Full description about the patient about personal detail and phone number, and then Disease and what treatment is going on. Passenger booking consisting of train, date, from-station, to station, coach, seat and passenger name.Ħ.A sequence number so the stations in the route of a train can be ordered by sequence number.Timeout (same as time in if it does not stop).Also, for simplicity, assume that for each train, for each station on its route, you store. You can assume for simplicity that each train reaches its destination on the same day and that every train runs every day. Train schedules recording what time a train passes through each station on its route.All the tracks put together to form a graph. You can assume for simplicity that only one track exists between any two stations. Railway System Database ProjectĪ railway system, which needs to model the following: Each instructor can take any number of courses, and a course can be taken by only one instructor.Ī student can enroll in any number of courses and each course can have any number of students. For each department, there is an ahead, and an instructor can be the head of only one department. Many instructors can work in a department, but an instructor can work only in one department. Each department can offer any number of courses. 4. College Database ProjectĪ college contains many departments. The items can be ordered from one or more suppliers. A bank account is required to settle the bill. The items can of different classes based on their prices.īased on the quantity, the price of the item, and discount (if any) on the purchased items, the bill will be generated. A customer can purchase one or more items in different quantities. After registration, each customer will have a unique customer, user id, and password. The customer will provide the bank account number and bank name (can have multiple account numbers). Online Retail Application Database ProjectĪ customer can register to purchase an item.
Student Record Keeping System Database Projectĭesign goals: a student file that contains the information about the student, a stream file, a marks file, a fee file, concession/scholarship, etc. Inventory control management Database Projectĭesign goals: maintain a proper variety of required items, increase inventory turnover, reduce and maintain optimize inventory and safety stock levels, obtain low raw material prices, reduce storage cost, reduce insurance cost, reduce taxes. Also, don’t forget to check other Computer science projects. If you need someone who can do your database project, Check my SQL homework help.
0 kommentar(er)
