Team: Abu Rashed Khan(182-15-2155)
Intesarul Haque(182-15-2170)
Al Mahin Saad(182-15-2222)


Project Name: Library Management System

Description : There are 9 possible Entities(can be added more). This project will help a reader to buy/order,borrow or read only books
Each books and members will have primary ID and other informations. Member type can be student or other people. Employees can be manager,supplier or delivery man,their info will be added also. Only member can borrow books on a date and return it on time. They can also re-issue the books By extending time. If they don't re-issue on time,they will be fined accordingly. A Reader/customer can also place an online/offline Orders so there will be quantity,price and transaction. Customer's details will also be added. Every books author's details will be there. Number of attributes can also be increased.


Entity & attribute list:


1. Addbook (Book_id,Book_Name,Book_Code,category,Type(Borrow, Read only, Order),Date,Price) - Foreign key (author_id)

2. AddMember (Member_id, Name, DOB, Gender, Address, Email, Contact no,student_id, Member-Type(Student,Other))

3. Book_Lend (record_no,issue_date,return_date) - Foreign Keys (member_id,book_id)

4. Book_Return (return_id,fine,late_days) - Foreign Keys (member_id,book_id)

5. Orders (Order_no,Order_date,Quantity) - Foreign keys(cus_id,book_id)

6. Customer (Cus_id,Cus_name,address,gender,phone)

7. Transactions (transaction_id, Price, payment_method) - Foreign keys (order_no,book_id)

8. Employee (Emp-id,Emp_name,number,address,type,salary,stats,dob) - Foreign key (Cus_id)

9. Author ( author-id,name,phone,dob,gender,address)



Relationship -


Add_member entity has relationship with book_lend and book_return

Add_book has relationship with book_lend, book_return, Orders, Transaction and Author

Customer has relationship with Employee and Orders

Orders has relationship with Transction, Customer and Add_book

Employee has a relationship with Customer

Transaction has a relationship with orders

Book_lend has relationship with add_book and add_member

Book_return has relationship with add_book and add_member

Author has a relationship with add_book




Note: If you have any suggestion Sir,Please enlighten Us .

1.Nasrin Akter Borsha 182-15-2133
2.Rishad Amin Pulok 182-15-2117
3.Md. Sefatullah 182-15-2103
Project Title: Hospital Database Management System Description

Our project is about a hospital database management system. We plan to design such a database that consists all kinds of information that are related to a hospital. This project will help us to find diverse queries about a hospital. In our project a collection of information will be stored in tables in the forms of rows and columns. There will be several entities having different kinds of attributes which will help us to identify the entities. There will be relationship between the entities to describe them properly. We have thought various entities related to our project. Possible entities list is given below 1. Hospital 2. Patient 3. Doctor 4. Nurse 5. Bill 6. Ward 7. Account 8. Test .

Group Members:
1.Ashrak Al Arif Shohas 182-15-2171
2.Meherab Hossain 182-15-2143
3.Mahedi Hasan Bijoy 182-15-2150
Project Name: Movie Store Database

We made this project with our teammates about storing movies in a database where a person can search movies as per their desire and know detailed about it.

Group Members:

Najua Ferdush Mim 182-15-2217

Abdullah Al Shaykat 182-15-2105

Md. Sazedur Rahman 182-15-2169

Initial Step: First of all we make a survey about Saloon. Then we identified how a saloon works. Main points are:

1.Main Purpose of Saloon

2.What does a saloon contains?

3.What are the mandatory Entity needed in a saloon?

4.How the Entity will be related to each other.

Then in the second step we will draw a ER diagram to construct the first visual project that can be understand by normal people or client. In this ER diagram we will add some attributes to the entity which will what does a entity contains and how it will work.

In the ER diagram we will construct relationship among the entity to show how all the Entity connected to each other.



Then We will create a Schema diagram which will show us the advanced level of ER diagram. It will contains some table with relationship line.



Last we will create SQL file that will create the main database to help us work with our Saloon Database.

Group Member:
Name: Jacky Mong Marma ID: 182-15-2132
Name: Md. Mobarok Hossen ID: 182-15-2187
Name: Md. Ashraful Alam Akif ID: 182-15-2225
Bus Management System:
Description: We will design database for bus management system. Here our entities are Bus , Passenger, Reservations, Schedule, Aminities and Tracking table. Every table have many attributes. In the below we also design ER diagram And Schema diagram. From the Schema diagram we will develop SQL. From the SQL we get some result and we also find the many query from our SQL. I think this project is useful for mini bus company and also useful for our University. When we face to tracking the bus we solve the problem in this project. Here the all query and answer:

Group Members: 1.Mohammad Abdullah 181-15-2051
2.MD.Rahazul Amin 181-15-1896
3.MD. Firoz Mahmud Konok 181-15-1896
Project Title: Railway Management System.

Our project is about The Railway Management System facilitates the passengers to enquire about the trains available on the basis of source and destination, Booking and Cancellation of tickets, enquire about the status of the booked ticket, etc. The aim of case study is to design and develop a database maintaining the records of different trains, train status, and passengers.
This project contains Introduction to the Railways Management system .It is the computerized system of reserving the seats of train seats in advanced. It is mainly used for long route. On-line Management has made the process for the Management of seats very much easier than ever before.
In our country Bangladesh, there are number of counters for the Management of the seats and one can easily make Managements and get tickets. Then this project contains entity relationship model diagram based on railway Management system and introduction to relation model
.There is also design of the database of the railway Management system based on relation model.

Group Members:
1. Md. Ashraf Mahmud Shadhin 181-15-2033
2. Sha Taskin 182-15-2212
3. Md Mostofa Kamal 182-15-2097
Project Name: Student Management System

Student Management System helps educational institutions to manage data, communications and scheduling. It's really effective when we need to find out any student information. It is a one kind of software that stores data into database. In this system, you can find out all the information that actually stored in the database. The advantage of a Student Management system is that as a educational institutions you are able to keep proper track of data related to students. This includes areas such as fees being paid by students, examinations records of the students transport facilities being provided by the school and availed by the students, and usage of libraries and other school facilities by the students.

You can access data and more information by using a unique identification number of the student. In fact, apart from management people, students can also use these systems in order to keep track of their dues as well as class schedules.

Project Title: Blood Bank Management System

Project Overview:
Blood Bank Management System (BBMS) is database system to link between the donors and blood banks and act as an interface for the patient to find his/her desired blood in a fast and efficient way. It will make the blood transfusion service and its management more reliable and efficient than the conventional system. There are 6 entities in this project like Donor, Blood, Blood Bank, receptionist, Blood Bank Manager ,Hospital and Orders. First of all will collect blood from the donor and then deposit it in the blood bank. The receptionist will collect blood from the donor andthen put it in the blood bank under the manager .There will be many types of blood in the blood bank. There are different types of blood prices in the blood bank. This database will contain a lot of blood bank data. If the Hospital will need any type of blood can be found in this database from any blood bank easily.

* E-COMMERCE MANAGEMENT SYSTEM*

Group Members:

1. Sohag Raha(182-15-2164)

2. Palash Mandal(182-15-2092)

3. Arup Ratan Nag(182-15-2138)

Project Description:

Our project is about e-commerce management system. Already we have designed ER diagram and relational schema that is build in all types of information are related to e-commerce.This project will collaboration us to find various queries about e-commerce. In our project accumulation of information will be gathered in the tables in the forms of rows and columns. Here will be different entities having various types of attributes which will help us to noticed the entities. Now here will be a relationship between the entities to describe them properly.

Now we write down the possible entities are given bellow:

1)Customer

2)Order

3)Payment

4)Seller

5)Category

6)admin

7)Product

Relationship:

1)Customer and order(one to many)

2)Customer and payment(one to many)

3)Order and payment(one to many)

4)Seller and product(one to many)

5)Admin and product(one to many)

6)Categories and product(one to many)

7)Order and product(one to many)