Verified Document

Business Database Technology Term Paper

Business Database Technology Scenario

The focus of this project is to design a database program for a company called Home Sweet Home that specializes in the management of properties on behalf of owners. The company offers a complete rental service for customers willing to rent furnished properties. The services delivered by the Home Sweet Home include advertising of properties in then local and national press. The company also carries out the interview and organize visit to prospective renters as well as negotiating the lease agreement. Once a customer rent a property, the company assumes the responsibilities of carrying out the regular property inspection.

Entities are the object used to track the database, and each entity is stored in the database. The entity assists in designing the ERD (entity relation diagram). This paper identifies the entities that need to be used in the database design for the Home Sweet Home. The principal entities needed in the design of ERD (entity relation diagram) are as follows:

Entities

Branch office: The Company has branch offices scattered across the United States.

Staff: The company staff is in charge of day-to-day administration of the company.

Staff next of Kin: The person very close to a member of staff.

Property for rent: The properties that the company offers to customers.

Property...

The attributes are the column in the database table that tracks individual fields. The attributes of the database Home Sweet Home are as follows:
Entity

Attribute

Branch offices

Branch number

Address:

street, area, city,

Telephone number

Fax number

Staff

Staff number,

First name

Last name

Address:

street, area, city,

Telephone number,

Gender,

Date of birth,

Social Security Number (SSN),

Job title (position),

Salary,

Date joined the company.

Staff next of Kin

Next-of-kin's…

Sources used in this document:
Reference

Hoffer, J.A. Ramesh, V. & Hiekki Topi, H.(2012). Modern Database Management (10th Edition) . Prentice Hall.USA.
Cite this Document:
Copy Bibliography Citation

Related Documents

Database Technology Administration Database Technology
Words: 4402 Length: 15 Document Type: Essay

" "STUDENT INFORMATION TABLE" ( "STUDENT ID" CHARACTER (4) NOT NULL, NAME CHARACTER (25) NOT NULL, "STREET NUMBER" CHARACTER (10) NOT NULL, "STREET NAME" CHARACTER (25) NOT NULL, CITY CHARACTER (25) NOT NULL, STATE CHARACTER (10) NOT NULL, EMAIL CHARACTER (25) NOT NULL, "PHONE NUMBER" CHARACTER (15) NOT NULL ); CONNECT RESET; SQL FOR Book_Information CONNECT TO LIBRARY; CREATE TABLE "USER"; CREATE TABLE BookInformation ( "BookISBN" CHARACTER (10) NOT NULL; "AUTHOR" CHARACTER (25) NOT NULL; "TITLE" CHARACTER (50) NOT NULL; "PRICE" CHARACTER (10) NOT NULL; CONNECT RESET; SQL STATEMENT FOR

Technology Business Processes Technology Mediated Organizational...
Words: 3360 Length: 12 Document Type: Essay

Technology Business Processes Technology Mediated Organizational Improvement: Spotify's Marketing Mix The proliferation of the personal computer, the high speed internet connection and the personal listening device have all have a dramatic change on the way that consumers acquire and use music. The inception of digital media and file compression has changed the rules of music acquisition for the artist, the consumer and the retailer alike. For the consumer, the acquisition of music

Business Case for Investment Business and Technology
Words: 2534 Length: 7 Document Type: Essay

Business Case for Investment Business and technology investment Kudler Fine Foods is one of the food stores which have always worked towards satisfaction of its customers in every level. With the coming technology it has not been left out and has considered technology investment strategy that will see its customer feel a sense of satisfaction. The paper will analyze the business case for investment of Frequent Shopper Program in Kudler Fine Food. Scope Describing

Business Plan of Searchyyy.com a Meta Search
Words: 2289 Length: 7 Document Type: Business Plan

Business Plan of Searchyyy.com a Meta search engine Market Opportunity & Solutions Business Model and Strategy Search engine according to countries and languages Advertisement Revolution Social Networking and Blogging Sites Revenue Opportunities Sales and marketing plan Technology overview Technology implementation Intellectual property Competition Financials Current ratio ROE Debt to equity ratio (D/E) Management Organization and Ownership Organizational Structure Risks and mitigation Searchyyy.com, Inc. is Meta search engine which intends to provide a multi-category search engine to its users at a faster pace. The growing technology has evolved our lives. Users

Business Plan This Is a Business Plan
Words: 2119 Length: 7 Document Type: Business Plan

Business Plan This is a business plan of Scarves Unlimited. The business will be a partnership business between Andy, Brandy, and Savanna. The partners of the business intend to improve business operations, and ensure there is increased productivity in the business. Therefore, this business plan will clearly illustrate how the business plans to operate, market its products and services and introduce technology in its operations. This is aimed at ensuring the

Technology and Ethics Companies and Corporations Around
Words: 1142 Length: 4 Document Type: Essay

Technology and Ethics Companies and corporations around the globe are utilizing ever-expanding technology to help set and manage ethical standards and guidelines within the workplace. Additionally, utilizing such technology can help to shape the type of work environment or work culture that a company hopes to promote. In embracing technology and its capacity to work in conjunction with maintaining ethical standards within the workplace, company higher-ups and human resources are able

Sign Up for Unlimited Study Help

Our semester plans gives you unlimited, unrestricted access to our entire library of resources —writing tools, guides, example essays, tutorials, class notes, and more.

Get Started Now