DBMS project,
Budget: $30 – $50 USD
Hi All,
I thought of giving you a detail description of the final project in case of any student missed the class that I explained the project requirements.
You must have three deliverables (submissions).
Initially, you want to find a problem domain. For example, but not limited to, university, grocery store, car dealership, etc.
Please come up with a requirement document that lists the main requirements of the system.
Ex:
ABC car dealership is a leading dealer in city XYZ. ABC sells cars, trucks, and SUVs. They keep all their customer information in the system. Customer can buy one or more vehicles from the dealership. Customer is also associated with a lease or a car loan. ABC buys all their vehicles from different suppliers. They also keep tracks of these suppliers. ABC dealership want to keep track of the sales and lease. at a given time the customer should be able to search through the inventory and find their future dream car or SUV.
The above description is very brief and you may have a longer description of the domain.
I recommend you to submit the system requirement description too along with the E-R model.
Each deliverable and the assigned marks is given below.
1. E-R model of the proposed system - 50%
2. Logical schema of the database (After converting the E-R model into logical schema - SQL statements of table creations) - 25%
3. Whole system (Working system with sample data loaded) - This may include the User Interface too. (Data - 20%, UI - 5%)
I strongly suggest to use MySQL as your database.
I would like to see well designed UI.
The UI may be implemented with Java, C#, PHP, or any other programming language. You can use any framework that will make your work easier. This may include but not limited to Laravel (PHP), C#.Net, Spring (Java), etc.
The first part (E-R model) is due on September 29 2021.
A sample project will be uploaded and explained in the class very soon.
NOTE(E-R MODEL SHOULD BE DELIVERED ON OR BEFORE 28 TH 12PM EST)
I thought of giving you a detail description of the final project in case of any student missed the class that I explained the project requirements.
You must have three deliverables (submissions).
Initially, you want to find a problem domain. For example, but not limited to, university, grocery store, car dealership, etc.
Please come up with a requirement document that lists the main requirements of the system.
Ex:
ABC car dealership is a leading dealer in city XYZ. ABC sells cars, trucks, and SUVs. They keep all their customer information in the system. Customer can buy one or more vehicles from the dealership. Customer is also associated with a lease or a car loan. ABC buys all their vehicles from different suppliers. They also keep tracks of these suppliers. ABC dealership want to keep track of the sales and lease. at a given time the customer should be able to search through the inventory and find their future dream car or SUV.
The above description is very brief and you may have a longer description of the domain.
I recommend you to submit the system requirement description too along with the E-R model.
Each deliverable and the assigned marks is given below.
1. E-R model of the proposed system - 50%
2. Logical schema of the database (After converting the E-R model into logical schema - SQL statements of table creations) - 25%
3. Whole system (Working system with sample data loaded) - This may include the User Interface too. (Data - 20%, UI - 5%)
I strongly suggest to use MySQL as your database.
I would like to see well designed UI.
The UI may be implemented with Java, C#, PHP, or any other programming language. You can use any framework that will make your work easier. This may include but not limited to Laravel (PHP), C#.Net, Spring (Java), etc.
The first part (E-R model) is due on September 29 2021.
A sample project will be uploaded and explained in the class very soon.
NOTE(E-R MODEL SHOULD BE DELIVERED ON OR BEFORE 28 TH 12PM EST)