Reference no: EM1360638
Tiny College is a private College with many students. The unit student Accommodation proposes to construct a database to monitor the Accommodation of students in the University. Each student requiring Accommodation is required to complete an application form that contains full information on the student and the type of Accommodation required together with the duration of occupancy. Students have two choices, either to rent a room in the hostel or an apartment owned by the university. The hostel has only a few single rooms with room number, location number and monthly rental. The location uniquely identifies each room in all the halls under the control of the Accommodation unit and used when renting out the room to students.
Staff from the Tiny College Accommodation unit manages each hostel. The Accommodation unit also offers student apartments. Each apartment is uniquely recognized through the apartment number. Each apartment is fully furnished and can be occupied by three, four or five students per apartment. Each room in the apartment has monthly rental rate, room number and allocation number. The location number uniquely identifies each room and is used when renting out the room to students. The Housing unit inspects the apartment at fixed intervals to ensure that the apartment is constantly well kept.
The rental agreement is signed at the beginning of the academic year with the minimum rental period of one semester and the maximum period of one academic year. Students will pay the rental fee for the whole year and will be given an invoice at the beginning of every semester. If the rental payment is not settled within a stated period, two reminders will be issued.
a) Find the case requirements and analyze them.
b) A fully annotated E-R diagram 1 and 2 showing the entities, primary and foreign keys, composite keys and relationships.
c) A Relational schema of your database in 3NF, clearly indicating attributes, the data type of each attribute, primary and foreign keys, candidate keys, and which attributes are nullable, giving reasons. List any assumptions you need to make.
d) Listing of major queries in SQL (update, sorting, joining tables, conditions using the where and having clause, order and grouping, logical and comparison operators, set functions, sub-queries etc.)
|
Explain most countries create a list of hostile countries
: Explain Most countries create a list of hostile countries that require special permission before an exporter will be allowed to proceed.
|
|
Intelligence and achievement assessments
: Compare and contrast your selected intelligence and achievement assessments. How are the goals of the tests similar and different? How are the tests used? What are the purposes of giving these differing tests?
|
|
Accounting important questions
: Dave Ganz started a sole proprietorship by depositing $30,000 cash in a business checking account. During the accounting period the business earned $6,000 of net income and Ganz withdrew $2,000 cash from the business.
|
|
Explain each team should treat their product idea
: Explain Each Team should treat their product idea as a real business opportunity and Teams must be realistic and valid with their assumptions in every aspect of launching the new product.
|
|
Draw fully annotated e-r diagram showing entities
: Find the case requirements and analyze them. A fully annotated E-R diagram 1 and 2 showing the entities, primary and foreign keys, composite keys and relationships.
|
|
Elucidate how a firm production function
: Elucidate how a firm's production function is related to its marginal product of labor, how a firm's marginal product of labor is related to the value of its marginal product.
|
|
Isolated business problems
: Isolated business problems - How do problems in an organization affect other departments or functional areas of business?
|
|
What is its final kinetic energy
: Find out the magnitude of the amount by which the potential difference across the plates changes.
|
|
Measurement and test edition
: For example, if a test publisher has developed the second edition of an assessment, would it be appropriate for us to use the first edition. How do we know when it appropriate or not appropriate?
|