Answered step by step
Verified Expert Solution
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?
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 DataStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started