Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

All contents related to the question are posted. Can you explain what else is needed? Purpose: The purpose of this assignment is to explore the

All contents related to the question are posted. Can you explain what else is needed?image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Purpose: The purpose of this assignment is to explore the creation of tables and relationships in Microsoft Access. The assignment involves the creation of a database (albeit, not complete) to be used by a property management company. Database description: The database primarily stores information about property owners, tenants, properties and rental agreements. The tables and relationships are shown in the Entity Relationship Diagram (ERD) at the end of the assignment. Relationship and Table descriptions are also given. Please take a look at these before beginning the assignment. Instructions: 1. Create a new database called LastName_FirstName_Rentals.accdb. 2. Create each table using the descriptions at the end of this document. 3. Create all relationships outlined in the ERD diagram and using the relationship descriptions that follow. Pay attention to the Cardinality and Ordinality of each one. 4. Create a lookup combo box on the following fields: a. Property ownerID (show "lastName"), based on query. b. Property propertyType (show type as listed below, limit to list) c. Rental tenantID (show "lastName, firstName"), based on query 5. Create appropriate input format and masks for the following fields: a. Owner phoneNumber in the format of (306) 539-0888 b. Tenant phoneNumber in the format of 306-539-0888 c. Address streetName d. Address postalCode 6. Set up data validation on the following (decide whether you need field validation or table validation): a. Rental rentalCloseDate must be NULL or at least 30 days after the rentalDate. b. Rental depositCharged and depositRefunded must be >0 c. Rental depositRefunded must be less than depositCharged d. Owner email must be in proper email format 7. Add the data to each table shown below. You can test your tables/relationships by creating some basic queries that join two or more tables. Property Management Database ERD Table Descriptions: Relationship Descriptions Do not set Cascade updates for any relationships as all primary keys are Autonumber and cannot be changed. Sample Data

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Database Systems

Authors: Ramez Elmasri, Sham Navathe

4th Edition

0321122267, 978-0321122261

More Books

Students also viewed these Databases questions

Question

Why do companies purchase securities of other corporations?

Answered: 1 week ago