Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Show Word Doc Code and MySQL Code You were hired by the owner of Trulia Real Estate Emma Watson to create their MySQL Database. You
Show Word Doc Code and MySQL Code
You were hired by the owner of Trulia Real Estate Emma Watson to create their MySQL Database. You must do the following: Create the T e Trulia Real Estate MySQL Database on the command line or Terminal Create all the tables associated with the database, create all the attributes associated with the tables and apply their appropriate data types and constraints(null or not null) and implement any primary keys or foreign keys needed to establish relationships between the tables Comment all the statements you created and put your full name on every comment. Screenshot all your code (Including the error you have), put all screen shots in a word document, upload it and submit it via Blackboard by the due date. Reminder: ALL labs must be submitted via blackboard only. You must submit it before the due date. DO NOT email me your labs. I will not accept it. You can only submit the lab via blackboard one time. Like any real estate company we have sellers that want to sell their property. The agent will indeed list the property the seller is trying to sell and the agent gets a commission if they sell the property. A user looking for a property can be either a buyer or renter. A feature helps sell the property Below are the requirement for Trulia Real Estate Database: All sellers can be uniquely identified by their sellers identification number, they also have a mobile number and email address. All users (Except Sellers) can he uniquely identified by their User identification number. We also must know full name, email, mobile number, and a user type (can be a renter or home buyer) buyer) + All property can be uniquely identified by their property identification number, property type, full address of the property, the price of the property, listing date, Hoa Amount, number of bedrooms, number of bathrooms, property sqft, description, property picture A seller can sell any number of properties or rent out their property All agents can be uniquely identified by their agent identification number. We must also record their Full name, cell phone number, email, and commission rate An agent call be in-charge of listing any number of properties All features can be uniquely identified by their feature identification number. We must also know the feature namne, and description, If a property has a feature. The identification number of the property will be shown in the features tableStep 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