Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 7024

The development of the conceptual schema and/or the logical model and/or the physical settings of a database.

5
votes
You can consider the web and mobile as just delivery interfaces to the functionality/services for your application. With this regard the backend functionality (server side - processing etc), should be …
answered Dec 17 '12 by Stephen Senkomago Musoke
1
vote
Since your plan is to re-use schedules I would recommend a change in your thinking as follows: a) Each service location can have one or more schedules - called location schedules (basically this is a …
answered Jun 23 '12 by Stephen Senkomago Musoke
6
votes
I would recommend modeling it as a sale with an adjustment for the trade-in, assuming that as a car dealer you accept trade-ins without a related sale of a car. Therefore within your system you re-u …
answered Jun 27 '12 by Stephen Senkomago Musoke
3
votes
I think the question of duplicated data depends on the meaning of the relationship between the two users. For example if the relationship is who is following who, then User 1 can follow user 2, but th …
answered Jun 29 '12 by Stephen Senkomago Musoke
0
votes
My thinking is as follows: a) I would keep all person information in a single table whether they are customers or employees - including login information b) Create a customer table with a link to Pe …
answered Oct 14 '12 by Stephen Senkomago Musoke
1
vote
You need to have a rentals table which has the following minimum columns: id - unique identifier for the rental an autoincrement field roomid - FK to the id of the room startdate and enddate - of t …
answered Mar 15 '13 by Stephen Senkomago Musoke
2
votes
I would also suggest the following: Add a movie genres table - as a movie can have one or more genres Split up the movie_showing table as follows: movie_showing - id, movie_id, cinema_id, details …
answered Mar 22 '12 by Stephen Senkomago Musoke
2
votes
First of all since you are using MySQL, go for InnoDB which allows you to create relationships between the different tables (not dbs) You need three tables: a) categories (db3) - I think you will u …
answered Apr 11 '12 by Stephen Senkomago Musoke
1
vote
The overall approach is as follows: a) An Entity-Attribute-Value model approach to tackle the attributes of the different devices to a device type. Each device type will have a list of attributes w …
answered Mar 17 '12 by Stephen Senkomago Musoke
4
votes
The balance is a computed amount based on certain business rules, so yes you do not want to keep the balance but rather compute it from the transactions on the card and therefore the account. You wan …
answered Jan 29 '13 by Stephen Senkomago Musoke
0
votes
Use an after insert trigger on the invoices table to set the value of the invoice number once the row has been inserted successfully. This means that you do not have to do the computation in your PHP …
answered Apr 22 '12 by Stephen Senkomago Musoke
1
vote
I have placed the answer here since I was restricted by the size of the comment field. This is based on an approach initially suggested by @FrustratedWithFormsDesigner. I would recommend MySQL 5.5 fr …
answered Mar 23 '12 by Stephen Senkomago Musoke
1
vote
The questions to answer Are the applications related to each other, or to a common user? Do the applications share data between each other? Are there any common data and functions that are common t …
answered Aug 25 '13 by Stephen Senkomago Musoke
3
votes
Recommendations are as follows: For access control use the groups instead of individual users. Create a group called public to which all users belong therefore any graphs assigned to public will be …
answered Jun 16 '14 by Stephen Senkomago Musoke
1
vote
Looking at your table structure means that while the actual row is small (many int values) there will be millions of rows. Yes you can use a database of your choice, MySQL, Oracle, SQL Server, PostG …
answered Feb 27 '12 by Stephen Senkomago Musoke

15 30 50 per page