scroll to top
Stuck on your essay?
Get ideas from this essay and see how your work stacks up
Word Count: 1,730
The Physical Design A physical design is a specification for database implementation At this phase of development you must know the database platform youre going to use--perhaps SQL Server 70 on Windows NT Server 40 Microsoft Access on the desktop Oracle on the mainframe or some other platform To create a physical design you pull together all the specifications and models youve created so far then modify and optimize them for your target platform For example you need to modify all column properties including data types so that theyre specific to your target environment You can add extra columns that dont appear in the conceptual or logical models such as flag columns and timestamp columns that facilitate data processing You also need to size the database analyze data volume and use incorporate any replication or distribution plans and select candidate columns for indexing If youre thinking ahead youll also determine user roles groups logins and security permissions requirements for data retention archiving plans and failover and backup and recovery plans Creating a Physical Design The physical design is a composite of models that taken together form a complete or near-complete specification for implementing a database So what does a physical design look like Part of it the piece we ordinarily call the physical model looks like an expanded ERD as Figure 1 page 8 shows Other parts such as the Data Volume Analysis model and the Security Matrix also look familiar The physical model in Figure 1 is an expanded version of the conceptual model or ERD that was created First carefully review the logical model and then present it to colleagues critics and customers for feedback When discrepancies between the conceptual and the logical models or if the logical model does not support the requirements then adjustments to the conceptual model should be made accordingly I initially categorized authors as having attributes that referenced how they were to be paid PayToOrderOf PayToTaxID PayToAddress and
@Kibin is a lifesaver for my essay right now!!
- Sandra Slivka, student @ UC Berkeley
Wow, this is the best essay help I've ever received!
- Camvu Pham, student @ U of M
If I'd known about @Kibin in college, I would have gotten much more sleep
- Jen Soust, alumni @ UCLA