phalanx88
New member
- Katılım
- 15 Kas 2006
- Mesajlar
- 293
- Reaction score
- 0
- Puanları
- 0
merhaba hackhell kulanıcıları.benim bi maruzatım olacak yine anlayan arkdasşlara, başımda bi ödev varki sormayın.gecen gunde bir C projesı ıcın yardım almak ıstemıstım gerçi ama onu hallettmeye calısmıstım kendı basıma.bunun hakkında ise hiçbişe bilmiorum.ben yine ödev konusunu ingilizce yayınlayacam.SQL den falan bahsedıo.derslere pek gıtmedım bişe bılmıyorum ama soyle bı tahmın edersem SQL yardımı ile falan ufak bi veri tabanı olusturmamızı ıstıyorlar.işin garip tarafı bu odev el yazısyıla verılecek.cumlelerden sekıllerden olusan bı veritabanı istiyolar sanırım.olaydan anlayan ama turkcesı lazım dıyen varsa cevırmeye calısıp onu da koyarım ama basıt ıngılızce kullanılmıs zaten acıklarken ,umarım bir çare bulunur.
In this homework you are expected to design a database for students at Bogaziçi University. Assume that the database is going to be used by registration office, advisors and students to manage and query course registrations and by the library to manage book borrowings.
To do list:
1. Build a data dictionary for the database.
2. Draw the entity-relationship diagrams for the database.
3. Describe the tables you will create and the SQL statements for creating these tables.
4. For each of the following questions, give the SQL statement that will return the answer:
a. Which students take the course titled ISE 100 in the fall 2005 semester ?
b. What is the list of books borrowed by the student with firstname X and lastname Y ?
c. For how many days has the student with with firstname X and lastname Y kept the book titled ‘Discrete Mathematics’ ?
d. Which courses do the students who borrowed the books titled ‘Discrete Mathematics’ take ?
e. What are the email addresses of the students who are taking ISE 100 ?
f. Which students have date of birth year between 1985 and 1990 ?
In this homework you are expected to design a database for students at Bogaziçi University. Assume that the database is going to be used by registration office, advisors and students to manage and query course registrations and by the library to manage book borrowings.
To do list:
1. Build a data dictionary for the database.
2. Draw the entity-relationship diagrams for the database.
3. Describe the tables you will create and the SQL statements for creating these tables.
4. For each of the following questions, give the SQL statement that will return the answer:
a. Which students take the course titled ISE 100 in the fall 2005 semester ?
b. What is the list of books borrowed by the student with firstname X and lastname Y ?
c. For how many days has the student with with firstname X and lastname Y kept the book titled ‘Discrete Mathematics’ ?
d. Which courses do the students who borrowed the books titled ‘Discrete Mathematics’ take ?
e. What are the email addresses of the students who are taking ISE 100 ?
f. Which students have date of birth year between 1985 and 1990 ?
