DATABASE MANAGEMENT SYSTEMS AND PROGRAMMING-II
Draw an ERD for a Real Estate company based on the instructions below:
The firm has a number of sales offices in several cities. We need to store unique office no, address and city for each sales office. Each sales office employs one or more employee id, name , address , city and salary .For each sales office there is always one employee assigned to manage that office. An employee only manage one sales office s/he is assigned to.
The firm lists many properties for sale. The necessary attributes needs to be stored are property id, type(villa, apartment etc.) price and address.Each property must be listed with only one sales office but a sales office may have many properties listed.
Each property should have at least one or more owner and an owner may have many properties. For each owner we need to store unique id, name , phone no, address.
Data Structures And Data Organizations(CMPE242)
Laboratory work will be done at the laboratory.
Consider the following linked list node structure:
struct node *next;
Implement the following basic functions of the linear linked list structure:
Check empty list
int is_empty( struct node *header)
return 1; //TRUE
return 0; //FALSE
Create a node
struct node * newnode(int d)
struct node *temp;
Devamı için tıklayın