Tag Info

New answers tagged

0

I agree with Rick and I Michaels answers, and would go further. In my opinion you are talking about the difference between tables and the interface. I would question if you need to have a schedule table at all. I'd store each vehicle's details and service requirements. Personally id have different tables for make/model and the details of the items that ...


0

Take a look here for all the sample databases one could wish for. Also Google "oracle export to excel" for lots of ideas - either in Oracle itself (PL/SQL), through ODBC from Excel to Oracle and the good old traditional .csv. MySQL also provides a sample (Sakila) which might be good for learning and it's much less resource intensive than Oracle.


2

PostgreSQL comes to my mind. You have pgcrypto library for encrpyting data and there are drivers for .Net


0

As mentioned above MS-SQL server suits you're requirement: On how to proceed with MS SQL databases refer to below article: http://www.codeproject.com/Articles/4416/Beginners-guide-to-accessing-SQL-Server-through-C For data encryption, yes its possible depending upon the edition you are going to use: refer to this for further read on encryption via sql ...


0

SQL Server does encryption. Just research Transparent Data Encryption.


0

Both are OK designs, so now the problem is deciding between the two. Here are some things that I think you should consider as you decide which one is best. How similar are the non-essential columns in the Course Subscription and Lesson Subscription tables? If they are very similar then records which contain only a course subscription in the Subscriptions ...


1

Think about how what kind of queries and reports you want to run against your data. Lets say for example you want to know how many students were absent in the month of 2013-10. Here is how that would look with each table: SELECT COUNT(*) FROM TABLEA WHERE DATE BETWEEN TO_DATE('2013-10','YYYY-MM') AND TO_DATE('2013-11')-1/24/60/60 AND STATUS='X'; SELECT ...


1

I would suggest something different than you have here- a separate table to record the student_class relation: | student_id | class | date | ----------------------------------- | 2 | 7 | 2013-10-24 | This would have one record for a student where a class was attended. For each class and date for which there is no record, it can be ...


0

It depends on your goal If you're trying to catalog your digital collection, there are tons of systems (iTunes, Windows Media Player, WinAMP) that have already been written which do that. If you're trying to learn how to design databases (and I encourage you to do that, as I've found it to be a wonderful form of expression), I recently answered a question ...


0

I'd look at SQLite if I were you but if you are you going to perform many analyses on this data - i.e. windowing functions -or CTEs (common table expressions), in that case, I'd go with PostgreSQL.


1

About _id generation, as long as you don't specify _id explicitly, Mongo would handle the id for you. It generates different nonce for different collection. So you should not need to worry about duplicated _id across different collection. Reference here. I agree with other answer, use same collection and put an extra field to differentiate regular user and ...



Top 50 recent answers are included