8. Suppose a parking spot in a college that students, Instructors and staffs can park their cars. Design a simple ER diagram for this environment

Draw ER diagram for a university library information system which stores information about books, journals, publishers, students, staff, borrowing of books, and reservation of books. Note that the library may have more than one copy for some of the books.

19. Most activities in a network diagram have a finish-finish relationship.     True   False

Draw an ER Diagram for the following Business Situation: A bank has a phone call system in which the costumer can call and talk to one employee and inquire of their existing account. Costumer can have two type of accounts, checking account or savings account, client can own both type of accounts. One of the assumptions which is being made with this project is all interactions will be over the phone. Clients would call in to the business’ account representatives who will have to search the client in internal database. Once the client has been searched in the database, representative will go forth and verify the client via personal information displayed through the database. Personal Information would include, full name, address, last 4 of social security, and account number. The project will assume that the business is domestic, and all clients are in the United States. Once the client is verified, representative can discuss business related queries, including transactional questions…

Question 1 Draw an activity Diagram in draw.io and screenshot it for me.   Scenario (please alert is in Draw.io)   Each semester the student will need to register the subjects that they need to take. The student needs to login to the system by inputting their student ID and password. The system uses that student ID to retrieve the intake of the student and based on their study plan, the system will display a list of subjects the student can register. The student can now click on the subject they wish to register. When the student is satisfied with the subjects chosen, the student will click the register button. The student may register more than 1 subject but the total credit hours for the subjects cannot exceed 20 credit hours. If it exceeds, the student has to choose all over again the subjects to register. If successfully registered, the student’s status in the system becomes “Active – Registered”. If the student does not register any subject for the semester, the status is…

Think of a one-to-one relationship that you would encounter in a work environment and discuss an example of it. (One example is employee and assigned parking space.)

Consider a restaurant software ordering system. The system should allow the waiter to handle customers’ orders by adding them, cancelling them, scheduling parts of the order (to make the starter arrive earlier than the main course). The cashier should be allowed to let customers pay for their meals, and print receipts. What is the SDLC model that is best to use in the application? Why?  Construct the Context Diagram of the software Construct the use case diagram of the software Construct the sequence diagram of the software (2 functions) Construct the conceptual framework of the software

Construct an E-R diagram for the following hospital: In this hospital, we have many patients (characterized by social security number, name, insurance, the admission date, and the date of check out) received by medical doctor. Each medical doctor in the hospital is characterized by: ID number, name, and specialization. For every patient, the medical doctor will perform one or more tests and examinations to diagnose his illness. Each test or examination is characterized by an ID, name, date, time, and result. In your ER-Diagram, you must specify the key for each entity and all relationship cardinalities.