C PROGRAMMING:
Define a set of data structures to store the information for a large real estate agency.
The agency can be described with: agency name, headquarters, address (street, city, state, zip), and the records for up to 100 real estate agents located in different cities.
Each realtor can be described with the following data: agent name, office address (street, city, state, zip), phone number, and houses for sale (consisting of up to 10 house records, each of which has the following components: address (street, city, state, zip), number of days the house has been on the market, and asking price.
Define whatever data types are needed.
Leave main function empty.
struct address
{
char street[100];
char city[50];
char state[20];
int zip;
};
struct house
{
struct address houseaddress;
int daysonmarket;
int askingprice;
};
struct realtor
{
char name[50];
struct address agentofficeaddress;
int phonenumber;
struct house housesforsale[10];
};
struct agency
{
char agencyname[50];
char headquarters[100];
struct address agencyaddress;
struct realtor agencyrealtor[100];
};
int main()
{
return 0;
}
C PROGRAMMING: Define a set of data structures to store the information for a large real...
Using C#, create a form-based program that will accept the following data and then store the data (in a pipe delimited file). full name street address apartment number City state zip Add ten records and store the data one line per record in one text file. Create a button that will read the file, parse the data and print each record on a separate line in a datagridview box. Since the pipes indicate the begin and end of each value,...
Description:In this assignment, you will write a program in C++ that uses files and nested loops to create a file for real estate agents home sales and then read the sales from the file and calculates the average sale for each agent. Each agent sold 4 homes. Use a nested loop to write each agent’s sales to a file. Then read the data from the file in order to display the agent’s average sale and the average for all sales....
Query #4 Please
"Which street in the suburb Camperdown has the highest average
rent"
in LISTING, the "type" column determines if it is "rent" or
"sell"
Thankyou
Views PROPERTY [pid, stno, stname, sttype, suburb, state, postcode, carspaces] Write the following queries in SQL in your PROPERTY database: SHAREDPROPERTY unitno,pid, proptype] AGENCY [agencylicence, agencyname, website, phone] 1. List all townhouses sold in the suburb Annandale in 2016 2. Find the suburbs that have not had any sales since 2017 BRANCH agencv,...
In this assignment, you will write one (1) medium size C program. The program needs to be structured using multiple functions, i.e., you are required to organize your code into distinct logical units. The following set of instructions provide the specific requirements for the program. Make sure to test thoroughly before submitting. Write a program, named program1.c, that reads and processes employee records (data about an employee). Each employee record must be stored using a struct that contains the following ...
E/R and UML Vacation Booking Agency The following data model is designed to hold information relating to vacation booking database. For this scenario we need to define the following facts: These facts define the requirements which the Database must meet and should be agreed between the Database User and the Database Designer prior to physical creation. Assuming that the booking needs to be helped by an agent from an vacation booking company, the Entities required should include: Customers Vacation Packages...
please use dia to draw the e-r diagram to create Entity -
Relationship Diagrams
then use MS access
This project requires you to create a database design. Your design will be documented in a set of Entity-Relationship Crow's Foot diagrams using the representation as shown in the lecture materials. Draw a set of Entity-Relationship diagrams to model the following scenario. The Maggs Realty Company wants to track the Sales Offices that they have across all of Ontario They are interested...
I already did the assignment. Just please help me check it
right or wrong
Question:
Jorge’s Home Services LLC (JHS) is a home improvement retailer
in Northern Virginia. JHS
does not employ installers, but rather subcontracts the
installations out to a list of approved
installers. Whenever a customer comes to the store to request
an installation service, a JHS
agent will help create a contract for the installation and
instantly assign an installer to the job.
Afterwards, the installer will...
1) Create Conceptual Schema Diagram
2) Create a fully attributed Loagical Data Model Diagram
3) Create the SQL script that will generate the data model
Develop an EER model for the following situation using the traditional EER notation, the Visio notation, or the subtypes inside supertypes notation, as specified by your instructor: Wally Los Gatos and his partner Henry Chordate have formed a new limited partnership, Fin and Finicky Security Consultants. Fin and Finicky consults with corporations to determine their...
(From the book Database Systems 10th editions by Coronel pg.142-143)The local city youth league needs a database system to help track children who sign up to play soccer. Data need to be kept on each team and the children who will beplaying on each team and their parents. Also, data need to be kept on the coaches for each team. Draw the data model described below:Entities required: Team, Player, Coach, and ParentAttributes required:- Team:Team ID number, Team name, and Team...
21. The local city youth league needs a database system to help track children who sign up to play soccer. Data needs to be kept on each team, the children who will play on each team, and their parents. Also, data needs to be kept on the coaches for each team. Draw a data model with the entities and attributes described here. Entities required: Team, Player, Coach, and Parent Attributes required: Team: Team ID number, Team name, and Team colors...