Entities
will continue later
| Name | Attributes | Iteration | Operations | Iteration |
| Venues | Name | 1 | | |
| | Phone Number | 1 | | |
| | Mobile Number (Optional) | 1 | | |
| | Location on Google maps | 1 | | |
| | Pictures | 1 | | |
| | Working Hours | 1 | | |
| | Rating | 2 | | |
| | Comment | 2 | | |
| | tags | 1 | | |
| | Schedule | 3 | | |
| | Parking | 1 | | |
| | Added By | 1 | | |
| | Expert Review | 2 | | |
| | User Review | 2 | | |
| Football Fields extends venues | Type of Surface (Grass, Hard Surface, etc. ...) | 1 | | |
| | Price per Hour | 1 | | |
| | Entrance Fee (If needed) | 1 | | |
| | Membership Required | 1 | | |
| | Number of football fields in the venue | 1 | | |
| | Light (Yes/No/Unknown) | 1 | | |
| Studios extends venues | Price per Hour | 1 | | |
| | Number of Rooms | 1 | | |
| | Instruments | 1 | | |
| | Instruments and Effects Rental + Prices? | 1 | | |
| | Recording (Yes/No/Unknown) | 1 | | |
| Restaurants extends venues | Type | 1 | | |
| | Minimum Charge | 1 | | |
| | Menu | 1 | | |
| | Avg Pricing | 1 | | |
| | Alcohol | 1 | | |
| | Party & Birthday Hosting | 1 | | |
| | External Catering | 1 | | |
| | Cuisine Type | 1 | | |
| | Restaurant Size | 1 | | |
| | Open Air Area | 1 | | |
| Events | Name | 2 | Invite people | 2 |
| | Locations | | | 2 |
| | Host | 2 | | 2 |
| | Ticket price | 2 | | 2 |
| | Time and date | 2 | | 2 |
| | | | Facebook | 3 |
| User | Username | 2 | Register User | 2 |
| | Password | 2 | Delete User | 2 |
| | Email | 2 | Delete User | 2 |
| | Telefone# | 2 | User Login | 2 |
| | Profile Pic | 2 | User Logout | 2 |
| | Number of comments | 2 | Insert Comment | 2 |
| | Number of posts in forum | 2 | Upload Pictures | 2 |
| | Admin rights | 1 | Comment and Rate Venue | 2 |
| | Venues added | 2 | Add venue | 2 |
| | Rating | 2 | View User Details | 2 |
| | | | Edit User Profile | 2 |
| | | | Send other user PM | 2 |
| | | | Report User | 2 |
| | | | Report Comment | 2 |
| | | | Report Venue | 2 |
| Search Result | Name | 1 | View/Open search result | 1 |
| | Type | 1 | | 1 |
| | Matches | 1 | | 1 |
| Address | City | 1 | | |
| | District | 1 | | |
| | Postleitzahl | 1 | | |
| Comments | Text | 2 | Create/Post Comment | 2 |
| | Date | 2 | Edit Comment | 2 |
| | Author | 2 | Delete Comment | 2 |
| | | | Search comments | 2 |
| | | | Rate comment | 2 |
| | | | Report comment | 2 |
| Search | | | Search by string | 1 |
| | | | Browse by venue attributes | 1 |
| | | | Sort search result | 1 |
| Forum | | 2 | | |
| Blog | | 2 | | |
Venues
Shared Attributes
- Name
- Address
- Phone Number
- Mobile Number (Optional)
- Location on Google maps
- Pictures (Can be uploaded by us, registered user and/or football field owner)
- Working Hours
- Rating
- Comment
- tags
- Schedule
- Parking
- Added By (if there is an 'added venue' 3and user yeb2a lazem yeb2a attribute hena)
- Expert Review (Could also be replaced by User Review like in IMDB, it would save us lots of work later on)
- User Review (read above)
Operations
Football Fields
Attributes
- Type of Surface (Grass, Hard Surface, etc. ...)
- Price per Hour
- Entrance Fee (If needed)
- Membership Required
- Number of football fields in the venue
- Light (Yes/No/Unknown)
Operations
Studios
Attributes
- Price per Hour
- Number of Rooms
- Instruments (bass amp, guitar amps, drumset, ...)
- Instruments and Effects Rental + Prices?
- Recording (Yes/No/Unknown)
Operations
Restaurants
- Minimum Charge
- Menu
- Avg Pricing
- Alcohol
- Birthday & Party Hosting
- External Catering
- Cuisine Type
- Restaurant Size
- Open Air Area
Operations
Events
- Users can create Events and Admins can create Events
- Featured (y/n to differentiate between admin crts and users crts and possibly paid features
Short Articles
- Title
- Text
- Author
- (Category?)
User
Attributes
- Name
- Email
- Telephone number (Optional)
- Profile Pic
- Number of comments
- Number of posts in forum
- admin rights
- Venues added
- Rating (from admins and users aw momken according to the venues he added, mel2akher to identify whether this is a troll or real user)
Operations
- Register User
- Delete User
- User Login
- User Logout
- Insert Comment (Registered User)
- Upload Pictures
- Comment & Rate Venue (Reg. User)
- Add Venue
- View User Details (Registered User)
- Edit User Profile (User's own profile)
- Send other user Personal Message
- Report User
- Report Comment
- Report Venue
Search Result
Attributes
- Name
- Type
- Matches (how is this result related to the search)
Operations
Address
- City
- District
- Postleitzahl
Comments
Attributes
Operations
- Create/Post Comment
- Edit Comment (Same user's comments only)
- Delete Comment (Same user's comments only)
- Search comments? eh el nezam that we make the user able to search for keywords within the comments
- Rate Comment (zay youtube)
Non-Database related features
Because not only features can be modelled as an entity the other functionalities of our website will be listed here
Search
- String search with autocompletion
- Browse by venue attributes
- View search results with sorting
Forum
Blog
Introduction
That's a place for the ideas about the features that should be included in the website....again hossi no sharameet
#Hatem: ana ra2yi en henna momken ne7ott el afkar el advanced ya3ni el ghaleban mesh hane3melha fel awel 3ashan bardo law el mawdoo3 meshi ne3raf ne implement it be sehoola. We can divide the features in criterias like:
- Must have
- Nice to have
- Not now
What should the website/application do? (Features)
- View information on a football field (Registered and Non-Registered User)
- Search Footbal Fields (Autocompletion) by: (Should this be Search by or Browse by??)
- Name search
- Address map/dropbox
- Type of Surface dropbox
- Price per Hour (max)
- Working Hours (opening/closing)
- Membership Required (yes/no) checkbox
- Number of fields in venue (min)
- View search results with sorting
- Forum
- Organize events like in www.doodle.com
Hatem Comments
I recommend a simple search and an advanced search (browse or filter search) zay facebook zaman aw studivz
i'll add more useful additions later. instead of focusing on your own interests, try to imagine what the rest of the population that is not 18-25 and doesn't have a cock wants to do.
i'm rly much liking the google mapz thingy
lol, the non-database items contain extremely database relevant functionalities. creator plz review
eh nezam Short Articles... what do you exactly mean? elaborate shwaya ya reet 3ashan it seem very similar to the blog idea... we ba3den non-database items 2a2sod things you cant define as an entity... heya di moshkelet el entity model howa ma3mool 3ashan el database
There are inconsistencies between the list and the table....whoever adds, changes something in the list please make sure the change or addition is reflected in the table and vice versa
tayeb 3amatan somebody add "view user details" for the operations on users plz. kthx