Skip to content

SQL Database (Sql Server) Project From-Scenario-To-Product ✌🤷‍♀️

Notifications You must be signed in to change notification settings

AhemdMahmoud/From-Scenario-To-Product

Repository files navigation

The Real Estate

The Real Estate (House Price Predictor) SQL Database (Sql Server) is designed to manage and organize data related to properties, users, transactions, predictions, and other entities within the context of a real estate system. The database supports functionalities such as property search, prediction of house prices, user transactions, and more.

Scenario

New users register on the Real Estate platform, providing their username, password, email, and specifying their user type (Buyer/Seller/Agent). Users log in to the system using their credentials, initiating a session. User authentication is mandatory for all subsequent actions. Users, predominantly buyers, perform property searches based on criteria such as location, budget, and features. The system records each search in the user's search...........

In this project I discussed these points

  1. documentation
  2. ERD
  3. Relational schema
  4. Sample Data in tables
  5. Queries(DDL,DML,DQL) & output
  6. Views
  7. Interface

ERD

ERD_ob

⚠ In this ERD I clarified entities attributes relationships (participation ,cardinality) and you can see this in documentation

Relational schema

sg

Sample Data in tables

User table sample data

Property table

san

sample view

view

PropertyPredictionView

view

interfrace

interface

⚠ you can try Queries and see output ,try the other points

About

SQL Database (Sql Server) Project From-Scenario-To-Product ✌🤷‍♀️

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages