Question

In: Computer Science

consider the victoria university information technology department, department has setup a small library for NIT5130 students....

consider the victoria university information technology department, department has setup a small library for NIT5130 students. The department library maintains a checkout list ( CALL NO, USER ID, DATE REQUESTED) of all the books borrowed by students, Every student record consists of User ID, User name, Borrow limit, Number checked out, and fines. Suppose that the library will have multiple copies (CALL NO, AUTHOR NAME, PUBLISHER, ISBN, DATE PUBLISHED) can have multiple authors (AUTHOR NAME, DATE OF BIRTH, COUNTRY OF BIRTH, DECEASE BIRTH). You have volunteered to set up a database system for the library,

Draw an Entity relationship diagram for the IT department library

Solutions

Expert Solution


Related Solutions

Consider Ghana Technology University College, of which the students are the product of the manufacturing process....
Consider Ghana Technology University College, of which the students are the product of the manufacturing process. A. What will be quality from the producer’s perspective (producers in this case are lecturers) and administrator’s? at least five B. What will be quality from the consumer’s perspective? Consumers in this case are Students. at least 5 C. What will be quality from the consumer’s perspective? Consumers in this case are employers. At least 5
A University Library has many items available for its students; some can be checked out and...
A University Library has many items available for its students; some can be checked out and others cannot. Among those that can be checked out are journal (i.e., a literary journal) and digital video disk (i.e., a DVD). These two types have many attributes in common such as title, publisher, and dewey decimal classification. Design a class to represent the library item that would capture the common features among journals and DVDs. Then, design journal and digital video classes that...
Problem Description Students in Computer Information Systems (CIS) department at a local university are required to...
Problem Description Students in Computer Information Systems (CIS) department at a local university are required to do some group-projects in their classes because their instructors believe the skills and competence to work as an effective team are important to assure a successful IT project. Group project helps IT students apply system design knowledge, solve real world business problems, enhance learning effective team skills, improve students’ business communication skills, and serve back to the community. In order to ensure an effective...
The university finance department wants to know if the average age of students at their university...
The university finance department wants to know if the average age of students at their university is greater than the average for other universities. A random sample of student records is taken from the own university (population 1) and a random selection of student ages from other three universities are taken (population 2). A significance level of 0.05 is chosen. The null and alternative hypotheses are: ?0: ??: The samples are selected, and the results are: ?1 = 28,7 ?????   ?1...
Consider a university medical services department. A1.1. Consider a university medical services department. Describe what could...
Consider a university medical services department. A1.1. Consider a university medical services department. Describe what could be the typical information items that is kept within the information system of such a department. A1.2. What should be included in a typical physical vital records inventory specifically for at least one type of data records at this type of medical services department which is needed for business recovery planning.
Consider for the following subquestions a university medical services department. - Consider a university medical services...
Consider for the following subquestions a university medical services department. - Consider a university medical services department. Describe what could be the typical information items that are kept within the information system of such a department. -What details should be included in a typical physical vital records inventory specifically for at least one type of data records at such a medical services department which is needed for business recovery planning. -Describe the typical functions of a university medical services department...
Is there a difference between community college statistics students and university statistics students in what technology...
Is there a difference between community college statistics students and university statistics students in what technology they use on their homework? Of the randomly selected community college students 67 used a computer, 86 used a calculator with built in statistics functions, and 22 used a table from the textbook. Of the randomly selected university students 40 used a computer, 88 used a calculator with built in statistics functions, and 39 used a table from the textbook. Conduct the appropriate hypothesis...
Role of Technology in Long-Term Care Using the South University Online Library and the Internet, find...
Role of Technology in Long-Term Care Using the South University Online Library and the Internet, find three articles describing the role technology will play in addressing the challenges ahead in long-term care. Summarize your findings and based on your learning, respond to the following questions: Which challenges in long-term care system remain unmet? Why? What changes can we expect to occur with the influx of baby boomers entering into the long-term care system? Why do you think technology is important...
Role of Technology in Long-Term Care Using the South University Online Library and the Internet, find...
Role of Technology in Long-Term Care Using the South University Online Library and the Internet, find three articles describing the role technology will play in addressing the challenges ahead in long-term care. Summarize your findings and based on your learning, respond to the following questions: Which challenges in long-term care system remain unmet? Why? What changes can we expect to occur with the influx of baby boomers entering into the long-term care system? Why do you think technology is important...
Washington City created an Information Technology department in 2013 to centralize information technology (IT) functions for...
Washington City created an Information Technology department in 2013 to centralize information technology (IT) functions for the city. The goal of the department was to reduce costs, avoid duplication of efforts, and provide up-to-date technology to all of the city’s operations. The fund was designed to be self-supporting; that is, all costs are to be recovered through user fees, but any excess of fees over expenses should be less than 5%. The pre-closing trial balance for the IT department as...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT