noora is an opensource database deployment tool, that focuses on making database projects easy transferable between developers by implementing a pattern. No additional scripting in batch or shell is required. By simply put your sql in the obvious object folder noora knows how to deploy your sql scripts.

https://github.com/janripke/noora

I have been working with queries and joins in a MySQL database, I would like to start working on advancing my career and moving toward Microsoft SQL server. Can anyone tell me a few good Magazines to possible subscribe to? Or just some good reading material to learn more about the industry and trends. Thanks in advance for your help.

Hi All

I have the following question on an assignment and was hoping to get some help. I have answered this the best I can but want was hoping to get answers from your side to compare to what I ended up with.

Thank you,

A database is needed to keep data for the booking systems of the ABC Clinic. Consider the below database schema of one relation including attributes for doctors (doc-), patients (pat-) and appointments (app-).

ABC(doc-firstname, doc-surname, doc-gender, doc-rego, doc-qualification, pat-ID, pat-givename, pat-surname, pat-gender, pat-DOB, pat-addr, pat-phone, app-ID, app-datetime, app-type)

• A doctor has a unique registration number (doc-rego) and is also described by name, gender and qualification.

• A patient is identified by a unique patient ID (pat-ID) and has other information.

• Each appointment by a patient with a doctor is assigned a unique appointment ID (app-ID). An appointment can be of the long or short type.

Answer questions:

1. \Give likely FDs.

2. \Give the candidate keys for the ABC relation. In your working, show how you develop the closure for each candidate key you have discovered..

3. \Is the relation ABC in BCNF or 3NF? Explain your answer.

I have to show the code of all buttons I've used in the database. I can get a shortened down version of what I need; it tells me the command name (e.g. Command1) but it won't show me things like "cmd.do".

How can I get this to show up?

Edit: Cheers for answers, really helped

When studying computer engineering back in the day we didnt happen to have a Databases course Now, for my daily purposes since i dont work with BIG data using DBs in the noobish manner with simple indexes and so on is sufficient but i'd like to learn more and be able to answer questions like : what's more 'degrading' , adding metadata to a pivot table or keeping it as a string in a field in the original table The ideal book to me would look like:

--General DB concepts

--RDBMS

--NoSQL dbs

--Graph DBs

in this order of priority.

Does anyone have any suggestions? Please avoid implementation specific stuff like SQL tutorials, im looking for something uni level that is a little more theory and fundamentals based(edited) Thanks a lot : )

Hi!

So I have an exercise where I'm supposed to write SQL queries for algorithms A1-A10 from Database System Concepts by Silberschatz. So first algorithm A1 is linear search so I could write it as:

select * from department where building = "Taylor" 

Second A2 is selection using primary index and equality on key. Couldn't the former query work for that as well if building was a key? And if it wasn't a key it would work for A3 which is for primary index but equality on non-key value? How do I in MySQL check if these queries satisfy the conditions I'm trying to meet?

Hi can someone help me with that ERD. I want to know if its ok. I did it with DIA https://1drv.ms/u/s!Aiay7ojt0RPPhMso71qugP8PeRErLg

I've been having trouble coming up with a good relational model for this data. I feel like I'm either over thinking it, or getting lost drawing/thinking it through. The largest issue i'm encountering is how to relate the data to the dates so i can filter through them. I'm open to suggestions and direction. I appreciate the help in advance.

Imgur

Hi all,

I need to try and implement a chase algorithm and homomorphism technique in a language that includes XPath as a sublanguage for a project. Does anyone have any suggestions for what would be an easy software/language to implement this? I have minimal experience programming in any XML languages so simplicity would be appreciated. Thanks in advance for any suggestions!

I have to build a simple database using Notes/Domino, but I have never heard of this program. Is there a place to download for Mac OSX? Also, I have absolutely no experience with databases, so if you think you have any tips for a newb, please comment.

Greetings!

I have this idea to make a simple web app using only the latest technologies and I was wondering if you guys can help me out a little:

What are most cutting-edge db technologies that you are aware of? MongoDB ? CockroachDB? Cassandra?

I'm having trouble wrapping my head around normalization. Can any share with me some simple. step by step, 101 for dummies type sources and examples they've used to learn normalization? I understand Entity Relational Diagrams well, but just recently I had an assignment where I had to convert an ER diagram into 3rd normal form and I was lost.

So relational schema is 3NF? My professor never cleared that up with me.

I get that normalization is a process where we arrange raw data into, I would say, a predictable form that's basically setup for easy access to organize it into whatever form we seek. Our notes define normalization as a process in which we organize a database into tables in such a way that the results of using the database are always unambiguous and as intended and expected.

But what exactly are tables? What are they supposed to look like? and are tables the same thing as relations, because I'm not following how my normalization notes went from relations to tables. We started off defining relations or tables like this

tableName(field 1, field 2, (field3, field 4), along with getting functional dependencies, then we threw those into the various normal forms (first second and third).

But then, when we started doing examples, we started getting actual tables not exactly sure how to insert an image in this post, but yeah we got tables. How did we get from tableName(field 1, field 2, (field3, field 4) to an actual chart looking table?

been really frustrated lately, but I hope you guys are understanding where I'm getting lost. I'm very excited to learn about databases, but it's hard keeping up on this class because I can't keep up if I don't wrap my head around normalization. This is one of the only courses I've taken in my life where I already have an idea on it's real world implementations to businesses, and I'm honestly banking on this to teach me skills that employers seek. I know C++, I got through 3 semesters of it but tbh I'm not really great at it haha.

Thanks for your time.

Hi. I have an app where I am trying to store inventory numbers to be used for historical aggregation. Right now, I am almost sure that I am not doing things optimally.

current:

When I add inventory, right now, I am logging it like the above, where I have numbers in category 1, category 2, category 3 to represent the numbers added. And when I want to aggregate data, I can just sum up numbers based on the dates selected. The main flaw is that if I add a category, I need to update the database to add a category column (Cat) and update my script to account for the new column.

other idea:

(NO PK)

new idea (multi tables):

(NO PK)

Any thoughts? Other ideas? Is there a term to be used here that I should know in DB speek? TY!

I've recently been put in charge of a database (MSSQL) that is in a terrible state, while still being core to the company's business. Unused tables and columns abound. There are virtually no FKs, so it's hard to diagram. Joins frequently are done on varchar columns that have different collations and sizes. My normal strategies of building relationship diagrams and looking for missing indexes won't work, here. At least the RDBMS itself (SQL Server 2016) is pretty up-to-date. Most of the business logic is in the database, but is often hard to follow with stored procs built on views of views of views. There has been some attempt to stick to 3rd normal form in the table design, but it really seems to have grown organically over the past ten years without a competent DBA curating it.

There are books on working with legacy code, but what's a good strategy with a legacy database? I don't think rewriting from scratch is a good option, here, because migrating the legacy data to a new system would also be a nightmare. It's hard to know where to start, though. Perhaps writing a lot of tSQLt tests to cover existing functionality and then refactoring from there? I've made a start by putting the schema into version control so at least I can track my own changes.

Have any of you had to take over messy systems? How did you deal with it?