Category: Databases

Be sure to show all of your work when completing these questions.
Q1.Consider the relation R, with key and functional dependencies shown below. Please normalize to BCNF. Be sure to show all of your work
R (A, B, C, D, E,F, G)
Key: A, B
F1: A, B-> C, D, E, F, G
F2: A-> D
F3: E-> G
F4: C->B
Q2. Given the invoice table with sample data,
Please determine an appropriate Key.
Then list the Functional Dependencies
normalize the relation to BCNF.

The purpose of this assignment is to develop data models and map Database System into a
standard development environment to gain understanding of data model development.
Then implement the data model using a commercially available database management
system development tool.
On completion of this assignment students will be able to:
a. Describe issues related to the integrity and security of database (DB) systems.
b. Make an informed and critical assessment of database management systems
(DBMS).
c. Develop data models and implement DB systems.
d. Analyse business decisions related to DB information systems.
e. Demonstrate skills in building a database application using a commercially
available database management system development tool.

Please read the questions carefully that you can find in the attached file to provide the right the answers, also please apply the conditions of each question.
Instructions:
-You must use this template in the file i attached, failing which will result in zero mark.
·You must provide two separate copies of the solution (one Word file and one PDF file). These files must not be in compressed format.
·You MUST show all your work, and text must not be converted into an image, unless specified otherwise by the question.
.The work should be your own, copying from students or other resources will result in ZERO mark.
.Use Times New Roman font for all your answers.
…………
Let me know if you need anything or need a further explanation. Good Luck!

The Access zipped file labeled a07r1NCCTS_LastFirst. is provided for you below use that and follow the New Castle County Technical Services Page 435 steps A-U in picture to complete the necessary assignment. If any further questions please do not hesitate to ask. Thanks! Also no code is needed just use the zipped file and follow the steps provided to you!
Rename file to a07r1NCCTS_BrarSukhpreet.

Consider a hypothetical online management system for the Saudi Electronic University that uses a relational database to manage its operations. This system needs to keep track of information about students (including student ID, name, major, and email), courses (including course ID, name, instructor, and department), and enrollments (including enrollment ID, student ID, course ID, grade, and semester).
Describe how you would design the relational model for this system. What tables would you create? What attributes would each table have? How would you use primary and foreign keys to represent relationships between the tables?

Learning Outcome (3):

Create Entity- Relationship model, Relational model, and write SQL queries.

Consider a database system for SEU that stores information about students, courses, faculty, and course enrollments. A student has a unique ID, name, major, and email. Each course has a unique course ID, name, department, and credits. Faculty members have unique faculty IDs, names, departments, and specializations. An enrollment associates a student, a course, a faculty member (as the instructor), and a semester. One student can enroll in multiple courses, but each enrollment is for only one course. A faculty member can instruct many courses, and each course can have multiple students enrolled over different semesters.
Based on this description, create the ER diagram.

Learning Outcome (3):

Create Entity- Relationship model, Relational model, and write SQL queries.

Define the Entity Integrity Constraint and Referential Integrity Constraint then explain their differences in a relational database. Explain why the DELETE operation may violate only the referential integrity and not the entity constraint. Provide examples to illustrate each constraint using the database system for SEU from question 1.

Learning Outcome(s): CLO1
Explain the concepts and architectures involved in the database development.

Using your own words, explain two advantages of the Three Tier Client-Server Architecture over the Single Tier Centralized DBMS Architecture.

Plagiarism is not allowed – follow the instructions – ask me if there is additional information required

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.
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, convert text into image or languages other than English or any kind of manipulation).
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.
Use Times New Roman font for all your answers

Consider the following relation that involves student data: What normal form is the relation in? Normalize it up to 3NF.
Given the EMPLOYEES relation below: What normal form is the relation in? What are the dependencies? Normalize it up to
3NF.

Consider the following relation that involves student data: What normal form is the relation in? Normalize it up to 3NF.
Given the EMPLOYEES relation below: What normal form is the relation in? What are the dependencies? Normalize it up to
3NF.

Define the Entity Integrity Constraint and Referential Integrity Constraint then explain their differences in a relational database. Explain why the DELETE operation may violate only the referential integrity and not the entity constraint. Provide examples to illustrate each constraint using the database system for SEU from question 1.
you can check the other questions in the file / please Read the instructions carefully / No plagiarism
· 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, convert text into image 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.
· Use Times New Roman font for all your answers.