Salesforce Data Modeling Practice Question

Are you ready to elevate your Salesforce data modeling expertise? Dive into our latest blog post where we present a challenging practice question designed to put your skills to the test. Explore real-world scenarios, fine-tune your understanding of Salesforce data structures, and gain valuable insights into effective data modeling practices. Whether you’re a seasoned Salesforce professional or just starting, this practice question is your key to honing your skills and enhancing your ability to design robust, scalable data models. Uncover best practices, overcome common challenges, and level up your Salesforce game with our engaging and practical data modeling exercise. Get ready to transform your approach to data modeling and take your Salesforce proficiency to new heights!”

1. Create a custom object named “Project” with the necessary fields to track project details.
2. Add a lookup relationship to link the Project object to the Account object.
3. Create a record type for the Case object that is specific to handling customer feedback.
4. Develop a validation rule for the Lead object that requires a phone number to be entered if the Lead Status is set to “Contacted.”
5. Create a validation rule for an Expense object to ensure that an Expense date field is not more than 30 days in the past.
6. Develop a validation rule for an Account object to ensure that an Account Name field contains at least three words.
7. Create a validation rule for the Opportunity object that prevents the close date from being more than 90 days in the past.
8. Create a record type for the Task object to distinguish between different types of tasks (e.g., follow-up, meeting, etc.) and customize page layouts accordingly.
9. Create a custom object named “Feature Request” to track customer feature requests, including relevant fields such as “Feature Name,” “Requester Name,” and “Status.”
10. School System Management:
    1. Create an Application Called School Management. And add all objects in this application.
    2. Create Three Objects
       1. School
          1. School Name 
          2. Address
          3. Phone number
          4. District (Picklist) Use field dependency district————-State
          5. State (Picklist)
          6. Email
          7. URL
          8. Total number of students (roll up summary (count) )
          9. Highest marks taken student ( roll up summary ( max) ) -Marks field
       2. Student
          1. Student Name
          2. ID (Auto number)
          3. Phone number
          4. School Name (Relationship field use master-detail)
          5. Parents Name (Relationship field use Lookup)
          6. Class
          7. Results (Picklist Pass and Fail)
          8. Subjects (Take multi picklist max 6 subjects are taken for student)
          9. Marks (Number datatype {max 600 marks} (If the student fails it should be 250 below) )
       3. Parents
          1. Parents Name
          2. Address 
          3. Phone number
          4. Income (Take picklist agriculture, govt job, business )
          5. Single parent (Check box field)
11. Car Rental Service Application:
    1. Create an Application Called Car Rental Service. And add all objects in this application.
    2. Object Name
       1. Contact
          1. Name (Text)
          2. Phone (Phone)
          3. Email (Email)
          4. Driving License (Text)
          5. Driving Experience  (Number)
          6. Ratings given (Roll up Summary)
          7. Bookings made (Roll up Summary)
       2. Payment – To store the payment details
          1. Car Id (Lookup)
          2. Customer ID (Master Details)
          3. Booking Id (Lookup)
          4. Payment Date (Date)
          5. Amount (Number)
          6. Credit Card Number (Text Encrypted)
          7. Card Owner Name (Text)
          8. Card Expiry Date (Date)
          9. CVV Number (Number)
          10. Status (Picklist- Pending, Done)
          11. Payment ID (Auto Number)
       3. Car – To Store Car Details
          1. Car Types: (Picklist)
             1. Mini
             2. Electric
             3. Go
             4. Prime
             5. XL
             6. Rental 
          2. Car Name (Text)
          3. Model Number (Text)
          4. License Number (Text)
          5. Car Model Year (Number)
          6. Fuel Type (Picklist- Petrol, Diesel, CNG Gas, Electric)
          7. Number of Cars Available (Number)
          8. Avg. ratings (Picklist – 1, 2, 3,4,5)
          9. Car ID (Auto Number)
          10. Charge Per Day (Number)
          11. No of Rating of the Car (Roll-up Summary)
          12. No of Bookings (Roll up Summary)
       4. Booking – To store the Booked Car details
          1. Contact Name (Master-Detail)
          2. Car Name (Master-Detail)
          3. Hire Date (Date)
          4. Return Date (Date)
          5. Status (Picklist – Booked, Not Booked )
          6. Payment Id (Lookup)
          7. Approval Status (Approved, Pending, Rejected)
          8. Car Returned (Checkbox)
          9. Penalty per day (Formula Field) Calculate penalty based on car type 
          10. Penalty for late return (Formula Field) Calculate the penalty for the number of days after the date of return 
          11. Tax (Formula) Calculate tax based on car type 
          12. Fare (Formula) Calculate the total fare for the late return bookings
          13. Booking ID (Auto Number)
       5. Review – Store the customer review regarding the cars and the Booking
          1. Customer Name (Master-Detail)
          2. Booking Id (Lookup)
          3. Car Id (Master-Detail)
          4. Rating (Picklist – 1, 2, 3,4,5)
          5. Date (Date)
          6. Review (Long Text Area)
    3. Validation Rules 

Booking object:

1. A car cannot be booked if it is not available 
2. A car cannot be booked if the customer does not have a driver’s license 
3. The car cannot be booked for more than 7 days 
4. The date of return should not be less than the date of hire 
5. If the car name is Benz, then the system admin only creates the record 
6. The payment amount and fare amount should be equal 

Payment Object:

1. Check the no of available cars and when a booking is made for the car 
2. Send an Email to the customer before 12 hours of the date of return 
3. Send an email to the customer after booking to make the payment with the booking ID and the fare amount 
4. When the car type is van submit for approval process 
5. Send confirm mail to the customer for the booking 
6. When payment status is processed, change booking status to confirmed 
7. Change the booking status to complete when the car is returned