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.