Question: The apartment site management program provides services for the charging of services such as dues accrued to the apartments in the site, hot water, cold

 The apartment site management program provides services for the charging of

The apartment site management program provides services for the charging of services such as dues accrued to the apartments in the site, hot water, cold water, pool maintenance, etc. These debts charged are accrued to the flat owner or the flat tenant according to the decision of the site management. Each debt accrued has a due date. If payment is not made by this due date, an interest of 0.15 of the main debt amount is applied every day. 1. Design the database of the Apartment Site Management Program explained above and carry out the following four steps. 2. Each CRUD operation to be made to the database should be done using stored procedures. 3. If the data in each table is deleted and updated, log information must be recorded. 4. The debts of an apartment must be shown by distinguishing the floor occupant and owner. While showing these debts, it is mandatory to take into account the delay interest. #c and sql

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!