Open Imaad08 opened 1 month ago
Very detailed presentation has some good features, is building off before which is very interesting to see has detailed data pieces, also very interesting and nice looking frontend overall looks very sleek and professional like something we would genuinely see as a cool and interesting project.
Topic Outline - NITD
1. Introduction
2. System Architecture
3. Frontend Design
4. Backend Design
/login
- User authentication./register
- User registration./buy
- Buy stocks./sell
- Sell stocks./portfolio
- View portfolio./history
- Transaction history.5. Database Design
6. Integration and Testing
7. Deployment and Maintenance
8. Appendices
Description of Data
User Data
UserID
(Primary Key) - Unique identifier for each user.Username
- User's login name.Password
- Encrypted user password.Email
- User's email address.FullName
- User's full name.RegistrationDate
- Date when the user registered.Stock Data
StockID
(Primary Key) - Unique identifier for each stock.TickerSymbol
- The stock's ticker symbol (e.g., AAPL, GOOGL).CompanyName
- The name of the company.CurrentPrice
- The latest price of the stock.PriceHistory
- Historical prices of the stock (could be stored in a related table).Portfolio Data
PortfolioID
(Primary Key) - Unique identifier for the portfolio entry.UserID
(Foreign Key) - Reference to the user who owns the portfolio.StockID
(Foreign Key) - Reference to the stock.Quantity
- Number of shares owned.PurchasePrice
- Price at which the shares were bought.PurchaseDate
- Date of purchase.Transaction Data
TransactionID
(Primary Key) - Unique identifier for each transaction.UserID
(Foreign Key) - Reference to the user who made the transaction.StockID
(Foreign Key) - Reference to the stock involved in the transaction.TransactionType
- Type of transaction (e.g., BUY, SELL).Quantity
- Number of shares bought or sold.Price
- Price per share at the time of the transaction.TransactionDate
- Date and time of the transaction.Price History Data
PriceHistoryID
(Primary Key) - Unique identifier for the price history entry.StockID
(Foreign Key) - Reference to the stock.Date
- Date of the recorded price.OpenPrice
- Opening price of the stock on the given date.ClosePrice
- Closing price of the stock on the given date.HighPrice
- Highest price of the stock on the given date.LowPrice
- Lowest price of the stock on the given date.Volume
- Number of shares traded on the given date.Session Data
SessionID
(Primary Key) - Unique identifier for each session.UserID
(Foreign Key) - Reference to the user associated with the session.SessionToken
- Token used to maintain the session.ExpiryDate
- Expiration date and time of the session.