Notes![what is notes.io? What is notes.io?](/theme/images/whatisnotesio.png)
![]() ![]() Notes - notes.io |
/*
Bir yükseköğretim kurumunda öğrencilerin kulup faaliyetlerini yönetmek için web tabanlı bir uygulamaya ihtiyaç vardır.
Ögrenci kulupleri birden fazla kategoride olabilir.
Örneğin sanat spor teknik gibi
Her öğrenci kulubunun bir Id si
adı
kategorisi
kuruluş tarihi
Danışman ögretim görevlisi
başkanı
saymanı
başkan yardımcısı ve üyeleri bulunmaktadır
Her öğrenci kulubu akademik yarı yıllar bir veya birden fazla etkinlik yapmaktadırlar
etkinlikler kapsamaında her etkinlik için birden fazla oturu,her oturum iin bir tarih,saat,oturumun konugu etkinlikler/faaliyetler kapsamında tanımlanmalıdır.
NOT: Bir öğrenci birden fazla kulube üye olabilir.
*/
Create Database ClubsManagementDB
Go
Use ClubsManagementDB
Go
Create Table Schools
(
SchoolId Int Identity,
SchoolName Nvarchar(50) NOT NULL,
Constraint PK_SchoolId Primary Key(SchoolId)
)
Go
Create Table ClubTypes
(
TypeId Int Identity,
TypeName Nvarchar(50),
Constraint PK_TypeId Primary Key(TypeId)
)
Go
Create Table Lecturers
(
LecturerId Int Identity,
LecturerFirstName Nvarchar(50),
LecturerLastName Nvarchar(50),
Constraint PK_LecturerId Primary Key(LecturerId)
)
Go
Create Table Clubs
(
ClubId Int IDentity,
ClubName Nvarchar(50),
ClubType Int,
LecturerId Int,
Constraint PK_ClubId Primary Key(ClubId),
Constraint FK_ClubType Foreign Key(ClubType) References ClubTypes(TypeId),
Constraint FK_LecturerId Foreign Key(LecturerId) References Lecturers(LecturerId)
)
Go
Create Table AcademicTerms
(
TermId Int Identity,
TermDefinition Nvarchar(50),
Constraint PK_TermId Primary Key(TermId)
)
Go
Create Table Members
(
MemberId Int Identity,
FirstName Nvarchar(50),
LastName Nvarchar(50),
Constraint PK_MemberId Primary Key(MemberId)
)
Go
Create Table ClubMembersTypes
(
MemberTypeId Int Identity,
MemberTypeDefinition Nvarchar(50),
Constraint PK_MemberTypeId Primary Key(MemberTypeId)
)
Go
Create Table ClubMembers
(
MemberId Int,
MemberTypeId Int,
ClubId Int,
Constraint FK_ClubMembers_MemberId Foreign Key(MemberId) References Members(MemberId),
Constraint FK_ClubMembers_MemberTypeId Foreign Key(MemberTypeId) References ClubMembersTypes(MemberTypeId),
Constraint FK_ClubMembers_ClubId Foreign Key(ClubId) References Clubs(ClubId)
)
Go
Create Table Activities
(
ActivityId Int Identity,
ActivityName Nvarchar(50),
ActivityDate Datetime,
ActivityTerm Int,
ActivityClub Int,
Constraint PK_Activities_ActivityId Primary Key(ActivityId),
Constraint FK_Activities_ActivityTerm Foreign Key(ActivityTerm) References AcademicTerms(TermId),
Constraint FK_Activities_ActivityClub Foreign Key(ActivityClub) References Clubs(ClubId)
)
Go
Create Table ActivitySessions
(
SessionId Int Identity,
SessionName Nvarchar(50),
SessionDate Datetime,
SessionSpeaker Nvarchar(100),
ActivityId Int,
Constraint PK_ActivitySessions_SessionId Primary Key(SessionId),
Constraint FK_ActivitySessions_ActivityId Foreign Key(ActivityId) References Activities(ActivityId)
)
![]() |
Notes.io is a web-based application for taking notes. You can take your notes and share with others people. If you like taking long notes, notes.io is designed for you. To date, over 8,000,000,000 notes created and continuing...
With notes.io;
- * You can take a note from anywhere and any device with internet connection.
- * You can share the notes in social platforms (YouTube, Facebook, Twitter, instagram etc.).
- * You can quickly share your contents without website, blog and e-mail.
- * You don't need to create any Account to share a note. As you wish you can use quick, easy and best shortened notes with sms, websites, e-mail, or messaging services (WhatsApp, iMessage, Telegram, Signal).
- * Notes.io has fabulous infrastructure design for a short link and allows you to share the note as an easy and understandable link.
Fast: Notes.io is built for speed and performance. You can take a notes quickly and browse your archive.
Easy: Notes.io doesn’t require installation. Just write and share note!
Short: Notes.io’s url just 8 character. You’ll get shorten link of your note when you want to share. (Ex: notes.io/q )
Free: Notes.io works for 12 years and has been free since the day it was started.
You immediately create your first note and start sharing with the ones you wish. If you want to contact us, you can use the following communication channels;
Email: [email protected]
Twitter: http://twitter.com/notesio
Instagram: http://instagram.com/notes.io
Facebook: http://facebook.com/notesio
Regards;
Notes.io Team