|
Annual Report FY [Year] [Add a quote here from one of your company executives or use this space for a brief summary of the document content.] |
|
IT403 Fundamentals of Databases |
|
Instructions: |
|
You must submit two separate copies (one Word file and one PDF file) using the Assignment Template on Blackboard via the allocated folder. These files must not be in compressed format. It is your responsibility to check and make sure that you have uploaded both the correct files. Zero mark will be given if you try to bypass the SafeAssign (e.g. misspell words, remove spaces between words, hide characters, use different character sets or languages other than English or any kind of manipulation). Email submission will not be accepted. You are advised to make your work clear and well-presented. This includes filling your information on the cover page. You must use this template, failing which will result in zero mark. You MUST show all your work, and text must not be converted into an image, unless specified otherwise by the question. Late submission will result in ZERO mark. The work should be your own, copying from students or other resources will result in ZERO mark.
|
|
|
3 Marks |
|
Learning Outcome(s): CLO4: Design a database starting from the conceptual design to the implementation of database schemas.
|
Question One
Reflect on the various types of database users mentioned in Module 1. Choose one type of user (e.g., database administrator, end-user, or designer) and answer the following:
- Describe their primary responsibilities and interactions with the database management system.
- Discuss at least two challenges they might face in their role, especially regarding security and data access.
- Suggest strategies that could be implemented to mitigate these challenges.
Answers:
|
2 Marks |
|
Learning Outcome(s): CLO4: Design a database starting from the conceptual design to the implementation of database schemas. |
Question Two
What is the best concept that describes each of the following definitions/descriptions?
- Database description; including details about the database structure, relationships, constraints, and data types.
- An element of the schema or an object within the schema, such as EMPLOYEE, DEPARTMENT, or SNN.
- Utilized by the DBA and database architects to define the conceptual schema of a database.
- Integrates all components into a single computer system, including the DBMS software, application programs, user interface processing software, and hardware.
Answers:
Write only one concept each.
1.
2.
3.
4.
|
3 Marks |
|
Learning Outcome(s): CLO4: Design a database starting from the conceptual design to the implementation of database schemas. |
Question Three
A company is building an e-commerce web application that serves thousands of customers simultaneously.
- Which DBMS client-server architecture would you recommend for the proposed application, and why?
- Identify the role of each tier using the e-commerce scenario.
Answers
Get this or a similar paper done in as fast as 4 hours, 24/7.
NB: We do not sell prewritten papers. All essays are written from scratch according to specific needs and instructions
Leave a Reply
You must be logged in to post a comment.