-
[Done] Create tables (as per the design you showed) with necessary constraints.
-
[Done] Enter dummy data into the tables. We expect reasonable number of tuples for each table.
-
[Done] Write a Stored Procedure to enter a record for property. Name of the stored procedure is
InsertPropertyRecord
(with necessary arguments/parameters for the attributes of the record). -> Anagha -
[Done] Write a Stored Procedure to display the properties (with all details) for a given ownerID. Name of the stored procedure is
GetPropertyRecords
(with Owner ID as the parameter). -> Adarsh -
[Done] Write a stored procedure to Print the tenant details for a given property. Name of the stored procedure is
GetTenantDetails
(with property id as the argument). -> Srikant -
[Done] Write a Stored Procedure to enter a record for a new User. Name of the stored procedure is
CreateNewUser
(with necessary arguments/parameters for the attributes like- user name, address, login credentials etc. of the record). -> Anagha -
[Done] Write a stored procedure that prints details of properties available in a city/locality. Name of the stored procedure is
SearchProperyForRent
(with city/locality as the argument). -> Atharva -
[Done] Write a stored procedure to print the rent history for a given property. Name of the stored procedure is
GetRentHistory
(with property id as the argument). -> Divyateja -
Each group will bring its laptop for demonstration. No paperwork expected. But bring the details of your table design/ER diagram shown during the phase-1 evaluation, for cross verification.
-
During the evaluation, we will ask you to execute stored procedures (randomly) at the SQL command prompt, by giving some random values for parameters. We may also ask you to explain the code of any random stored procedure you have written. No front-end is needed.
-
We will randomly ask a few viva questions (similar to what we did during the Phase-1 evaluations).
-
We expect above functionality. But, to make the project more elegant/complete, you may add things as per your interest, but we will not give any weightage to that extra work.
-
If you have doubts, ask towards the end of lecture on Monday. DO NOT EMAIL me for clarity.
thenicekat/PropertyManagementPLSQL_BITS_CSF212
A simple application to mediate management and sharing of properties between owners, tenants and view monthly reports for the property and the tenant.
Python