Free

Physical Design - Coursework Example

Comments (0) Cite this document
Summary
The author of this paper entitled "Physical Design" casts light on the concept of physical design. It is mentioned here that this coursework involves the review of diagram for the database to ensure that the design is normalized and complete…
Download full paperFile format: .doc, available for editing
GRAB THE BEST PAPER91.5% of users find it useful
Physical Design
Read TextPreview

Extract of sample "Physical Design"

Physical Design Introduction This is a work project that involves designing and translating data into an actual database. It involves review of diagram for the database to ensure that the design is normalized and complete (Bambara & Allen, 1999). Creation of database in SQL Server and tables in the new database, selecting appropriate data types for the columns, setting a primary key for each table, and setting allow nulls as appropriate also create a database diagram and relationships among tables (Dewson, 2012). Finally, provide some sample data to each table.
Review Design

Review of diagram for the database




















Creating database in SQL Server
USE [Master]
GO
CREATE DATABASE [LEASE] ON PRIMARY
(NAME = N'Lease', FILENAME = N'\\FSA\SQLDB\lease.mdf’,
  SIZE = 4GB, MAXSIZE = 10GB, FILEGROWTH = 2GB)
LOG ON
(NAME = N'Lease_log', FILENAME = N'\\FSA\SQLDB\lease_log.ldf’,
  SIZE = 2GB, MAXSIZE = 3GB, FILEGROWTH = 10%)
GO
Creating Tables
CREATE TABLE dbo. Lease Agreement
(
Lease_ID int, Primary Key,
Lease_Start_Date DATE, Not Null,
Lease_End_Date DATE, Not Null,
Deposit DECIMAL (15, 2),
Rent_Amount DECIMAL (15, 2),
Late_Fees DECIMAL (15, 2),
Apartment_ID int, Foreign Key,
Tenant_ID int, Foreign Key,
);

CREATE TABLE dbo. Building
(
Building_ID int, Primary Key,
Plot_No VARCHAR (255),
Building_Status VARCHAR (255), Not Null
Building_Name VARCHAR (255), Not Null
Bulding_Address VARCHAR (255), Not Null
Lease_ID int, Foreign Key
);

CREATE TABLE dbo.Manager
(
Manager_ID int, Primary Key
Manager_LastName VARCHAR (255), Not Null
Manager_FirstName VARCHAR (255), Not Null
Building_ID int, Foreign Key
Manager_qualification VARCHAR (255), Not Null
Manager_Expertise VARCHAR (255), Not Null


);

CREATE TABLE dbo. Tenant
(
Tenant_ID int, Primary Key
Tenant_LastName VARCHAR (255),
Tenant_FirstName VARCHAR (255),
Tenant_Email_Address VARCHAR (255),
);

CREATE TABLE dbo.Rent
(
Rent_ID int, Primary Key
RentAmount DECIMAL (15, 2),
RentDueDate DATE,
Lease_ID int, Foreign Key

);
CREATE TABLE dbo. Maintenance and Repair
(
Maintenance_Request_ID int, Primary Key
Date DATE,
Description VARCHAR (255),
Cost DECIMAL (15, 2),
Resolution VARCHAR (255),
Resolution Date DATE,
Tenant_ID int, Foreign Key
);

CREATE TABLE dbo. Expense Type
(
Expenses_Type_ID int, Primary Key
Repair VARCHAR (255),
Maintenance VARCHAR (255),
Utilities VARCHAR (255),
Apartment Cleaning VARCHAR (255),
Insurance VARCHAR (255),
);
CREATE TABLE dbo. Expenses
(
Expense_ID int, Primary Key
Cost DECIMAL (15, 2),
Expense Management VARCHAR (255),
Expense_Type_ID int,
);
Conclusion
The design has been implemented by SQL Server 12 to create database and tables. The design shows knowledge acquired during coursework. The project involved designing and translating data into an actual database. Running the database and SQL tables will give proper results that comply with project’s objective.
References
Bambara, J. J., & Allen, P. R. (1999). SQL Server reference. Indianapolis, Ind: New Riders.
Dewson, R. (2012). Beginning SQL Server 2012 for developers. New York: Apress.
Powell, G. (2006). Beginning database design. Indianapolis, Ind: Wiley. Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Physical Design Coursework Example | Topics and Well Written Essays - 500 words”, n.d.)
Physical Design Coursework Example | Topics and Well Written Essays - 500 words. Retrieved from https://studentshare.org/information-technology/1651377-physical-design
(Physical Design Coursework Example | Topics and Well Written Essays - 500 Words)
Physical Design Coursework Example | Topics and Well Written Essays - 500 Words. https://studentshare.org/information-technology/1651377-physical-design.
“Physical Design Coursework Example | Topics and Well Written Essays - 500 Words”, n.d. https://studentshare.org/information-technology/1651377-physical-design.
  • Cited: 0 times
Comments (0)
Click to create a comment or rate a document

CHECK THESE SAMPLES OF Physical Design

Physical Science

...?Physical Science Research Paper Science is defined as “The collective findings of humans about nature, and a process of gathering and organizing knowledge about nature” (Hewitt, Suchocki and Hewitt G-12). Many things are found in nature. Living creatures, like animals and plants, are plentiful specimens to be found in nature. Nonliving things can also be found in nature. Water and earth, for example, are nonliving things which can be readily found in almost all parts of the natural environment. The physical sciences have been created for the specific purpose of gathering and organizing knowledge about the nonliving natural world (Hewitt, Suchocki and Hewitt 8). The basic principles of...
3 Pages(750 words)Term Paper

Physical Geography

...? 20 Apr. Global warming: In the contemporary age, global warming has become a very serious issue. The world has progressed a lot because of rapid industrialization, though it has had some extremely negative effects on the environment. This paper tends to explore factors that have caused global warming, gives evidence to prove that global warming is a problem, analyzes the impacts of global warming on the environment and proposes some measures that a common man can take to play his part in reducing global warming. Various natural processes have caused global warming. Increase in the content of carbon dioxide in the atmosphere is the fundamental cause of global warming. For example, all animals and humans inhale oxygen and exhale... 20 Apr....
2 Pages(500 words)Essay

Physical Education

...? As society progressed to 21st century, one of the major emphasis has been placed on creating a society where the aspects of health and wellness arehighly emphasized upon. Since allocating tax money is a sensitive issue that is critical; one must look at all aspects of funding from the community. As a mayor, I would allocate around 15% of the overall tax money to build fitness facilities. For community users, the patrons will be charged at a discount price. Furthermore, sustaining a physical activity can be a huge challenge. The need for a recreation center is essential for various reasons. First and foremost is the fact that it safeguards children from engaging in other illegal activities. When children are growing up,...
3 Pages(750 words)Essay

Physical Architecture Layer Design

...? Physical Architecture Layer Design (Section) Due) Computer networking is a basic need for almost all modern systems compelling an organization to have at least two networked computers or devices. Physical layer architecture design specifies the distribution of the system across the networked computers in addition to pointing out the necessary hardware and software to be used. The paper explores on the different components of physical architecture design, network models, various architecture designs and the factors that affect the design of the physical layer architecture. Introduction...
3 Pages(750 words)Coursework

Physical Therapy

...? Physical Therapy Health sciences and medicine Physical Therapy Physical therapy is a branch of the medical profession associated withtreatment of disabilities and impairment of musculoskeletal function, it also promotes movement potential using examination (What is physical therapy, n.d.). An individual who specializes in this field is known as a physical therapist and performs medical examinations, diagnosis and the appropriate physical interventions to ensure that the musculoskeletal structures function effectively and efficiently. The field also includes consultation, research, education and administration. Licensing requirements...
4 Pages(1000 words)Essay

Physical Exercise

...R.Preeti 28/4/2007 Physical Exercise Introduction In today's fast-paced modern world, manhas no time to repose or lead a more relaxed life. He continue in pursuit of work, career building, fulfilling family responsibilities and financial stability. In this maddening rush and busy life, one loses out on important activities, like adequate food, sleep, relaxation and of course, physical exercise. Due to this, man's life has been plagues by lethargy, fatigue and varied forms of diseases. However, one needs to realize that physical exercise and activity is just as important as any other part of one's life. ...
2 Pages(500 words)Essay

Physical Geology

...Physical Geology Physical Geology Wherever we go in the world, the one thing above all others that will be unique is the natural landscapes. Everymountain, forest, desert, river, valley and ocean has its different characteristics and make-up. In fact, if we travel across the globe, we will find that no two landscapes offer same view or construction. It is fascinating to understand how the natural environment has developed, and what forces of nature have shaped the environment that we live in and the landscapes we tend to take for granted. The earth has evolved over billions of years. From a global mass of matter has been created the beautiful, picturesque, but sometimes savage and rugged landscape that...
7 Pages(1750 words)Essay

Physical Security

...PHYSICAL SECURITY Ans To answer to the first question one needs to have a proper understanding of the disaster management cycle. Given below is the image of the Disaster Management Cycle (which is not a standardized representation as many authors have different break-ups of the cycle): Figure 1: Disaster Management Cycle As can be seen from the afore-mentioned picture, there are essentially two parts to the entire process of disaster management namely, Risk Management and Crisis Management. In context with the problem statement, the afore-depicted points stand true as well. The emergency management plan should cover the following key aspects for the safety of the Maracana Stadium during the Olympic Games: Risk...
8 Pages(2000 words)Essay

Physical Science

... Operation of Circuit Breaker The turning on of portable heater in the room and subsequent opening of the room’s circuit breaker and the going off of the lights could be attributed to the high current passing through the heater or low resistance of the metal strip in the circuit breaker. To understand these postulations, it would be critical to understand the operation of circuit breakers which has been described by El-Sharkawi (31) as a switch which would automatically open when exposed to high current. The high current would cause a metal strip in the circuit to warm up and bend away from the circuit connection causing a break in the circuit. This situation could be reversed and normal operation restored after diagnosing... Operation of...
1 Pages(250 words)Essay

Design in Context of Physical Education

... Design in Context of Physical Education Introduction This study outlines resource design in context of physical education. There are wide array of resources which can be accessed by individuals who are a part of physical education field. Learning techniques are completely different for those individuals undertaking physical education. Sources required for physical education area are books, journals, websites, etc. These sources need to be stored properly in order to deliver maximum outcomes. 2.1 Principles of resource design Principles of research design in educational field encompass...
2 Pages(500 words)Essay
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.

Let us find you another Coursework on topic Physical Design for FREE!

Contact Us