1 / 8

Branch (Bno, Area, City, Pcode) Staff (Sno, FName, LName, Position, Sex, DOB, Salary, Bno)

Branch (Bno, Area, City, Pcode) Staff (Sno, FName, LName, Position, Sex, DOB, Salary, Bno) Property_for Rent (Pno, Area, City, Type, Rooms, Rent, Ono, Sno, Bno) Renter (Rno, FName, LName, Pref_Type, Max_Rent) Owner ( Ono, FName, LName) Viewing (Rno, Pno, Date, Comment).

bary
Download Presentation

Branch (Bno, Area, City, Pcode) Staff (Sno, FName, LName, Position, Sex, DOB, Salary, Bno)

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Branch (Bno, Area, City, Pcode) • Staff (Sno, FName, LName, Position, Sex, DOB, Salary, Bno) • Property_for Rent (Pno, Area, City, Type, Rooms, Rent, Ono, Sno, Bno) • Renter (Rno, FName, LName, Pref_Type, Max_Rent) • Owner ( Ono, FName, LName) • Viewing (Rno, Pno, Date, Comment)

  2. A list (Bno, Street, Area,Tel_No, Fax_NO) of branches located in Bay Area • A list (Pno, Street, Area, City) of properties for rent with 4 bedrooms or less than $1,000 per month rent • A list (Sno, FName, LName) of female mangers with salary between one to two million dollars • A list (Pno, Street, Area, City) of properties for rent located in SF, LA, NY, or DC

  3. A list (Pno, Street, Area, City) of properties for rent not located in SF, LA, NY, or DC • A list (Ono, Fname, Lname) of owners without any telephone

  4. The total number of branches • The total number of staffs • The total salary for male managers • The minimum salary for the female manager • The maximum rent to rent a property by a renter

  5. The average salary for male staff members • The average number of rooms in the single house type • The number of employees in each branch • The average salary in each branch • The average salary in each branch with more than 10 staff members

  6. The number of employees in each branch located in SF, NY, LA, and DC • The number of employees in each branch with more than 10 employees and located in SF, NY, LA, and DC • A list (Pno, Street, Area, City) of properties for rent managed by John Dow and owned by Sue Lee • A list (Sno, FName, LName) of staffs without supervising any property for rent • A list (Rno, Fname, Lname) of renters without looking any property for rent

  7. A list (Sno, FName, LName) of supervising a property for rent staff • A list (Rno, Fname, Lname) of viewing renters • A list (Sno, FName, LName) of the highest salary staff

  8. Student (Stuid, Stuname, Major, Credits) • Class (Course#, Facid, Sched, Room) • Faculty (Facid, Facname, Dept, Rank) • Enrollment (Course#, Stuid, Grade, Sdate)

More Related