There are multi-billion-dollar companies (Cerner, for example) whose sole purpose is to create hospital management systems that cost hundreds of thousands to millions of dollars. It sounds like you're biting off a big chunk to start your database design experience. I'd recommend that you scale back a bit (or a lot!) to learn the concepts and then work from there. Otherwise you're starting on a multi-year task with plenty of opportunities to get lost in all the details. If this truly is a university project that was assigned to you, I have to wonder what it is they're trying to teach you, especially someone who (evidently) hasn't been exposed to database design theory.