Hello,
Please do E-R model of the proposed system choose any topic it has 3 parts – consider all required computer languages given in description and need to do a proposal with all requirements
Course : Fundamentals of Database Systems
Final project details
1. E-R model of the proposed system –
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.
requirement description too along with the E-R model
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.
0 comments