here is the example I have for you:
I am trying to learn how to calculate table size, and to be honest I need a dumbed down explanation. Other explanations I have found on the EE website are too complicated. No need to calculate all the tables provided, just if someone could run through one table calculation on the "Tenants.sql" database, and one on the "Rental_Unit" database that would be real cool.
1. The "tbl_Tenant" table in database "Tenants.sql
2. The "tbl_Rental_Unit" in database "Rental_Unit.sql"
The dbms is MySQL. The ERD's are for two database that form the backend of a content management system for a large rental apartment corporation in Washington DC... its an exercise from my school book. I am not interested in specific dbms handling of table calculation, just the theory behind how to calculate table size. Preferably a step-by-step approach that a norom (backwards moron) like myself could understand.
There are no variable length fields, just fixed length.
The "tbl_Rental_Unit" table employs the use of data blobs for all the columns named "Schema_". These are very large pictures of schematics...
Thats all I have... please help...