March 4, 2014 at 3:59 am
Hello.
I would like to make a database for a university system, including "Employees , Teachers & Students" entities.
Actually all these 3 entities have some type of same attributes , and also "Name , FamilyName,BirthDate,...".
the major problem is that, can i allocate these details into the seprate table dependently by the name of, such as "GeneralInformation" and make ralations among 3 above entities .
And finaly is there any same sample? can you give me?
Thanks!
Livetecs
Time Tracking Software
March 4, 2014 at 7:28 am
aalianebhan (3/4/2014)
Hello.I would like to make a database for a university system, including "Employees , Teachers & Students" entities.
Actually all these 3 entities have some type of same attributes , and also "Name , FamilyName,BirthDate,...".
the major problem is that, can i allocate these details into the seprate table dependently by the name of, such as "GeneralInformation" and make ralations among 3 above entities .
And finaly is there any same sample? can you give me?
Thanks!
Livetecs
Time Tracking Software
This sounds an awful lot like homework. Why don't you post your ideas and we can give you some pointers.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
March 4, 2014 at 8:37 am
How about, instead of GeneralInformation, we think of those things as what they are, People. You can then create a People or Person table and there you can locate the things that make a Person a person. Then, you have to figure out what makes a person a student or what makes a person a teacher and those things will be put into other tables, but ones that related to the original Person table.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply