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