please use your own words don’t copy and paste (no plagiarism)
- Please use keyboard (don’t use handwriting)
- All answered must be typed using Times New Roman (size 12, double-spaced)
- I want answer with APA reference for per question
##The assignment should not contain sexual orientation or the like
Category: Databases
1.The paper should create a list of requirements for a Smart Highway with at lea
1.The paper should create a list of requirements for a Smart Highway with at least five (5) integrated Smart systems identified in your research with at least 40 requirements (total) for these five (5) Smart systems.
2. detailing your proposed trip on a
Smart Highway. The paper must include all five (5) of the integrated Smart systems identified in your
research and two (2) requirements for each of the five (5) integrated Smart systems.
You must submit two separate copies (one Word file and one PDF file) using the A
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.
3 Marks
Learning
Outcome (3):
Create Entity-Relationship
model, Relational model, and write SQL queries.
Question One
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?
Answer:
2 Marks
Learning
Outcome (3):
Create Entity-Relationship
model, Relational model, and write SQL queries.
Question Two
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.
Answer:
Learning
Outcome (3):
Create Entity-Relationship
model, Relational model, and write SQL queries.
2 Marks
Question Three
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.
Answer:
1 Mark
Question Four
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.
Answer:
please be careful of the note in the begininig and dont forgate the reference
please use your own words don’t copy and paste (no plagiarism) - Please use key
please use your own words don’t copy and paste (no plagiarism)
- Please use keyboard (don’t use handwriting)
- All answered must be typed using Times New Roman (size 12, double-spaced)
- I want answer with APA reference for per question
##The assignment should not contain sexual orientation or the like
You must submit two separate copies (one Word file and one PDF file) using the A
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.
3 Marks
Learning
Outcome (3):
Create Entity-Relationship
model, Relational model, and write SQL queries.
Question One
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?
Answer:
2 Marks
Learning
Outcome (3):
Create Entity-Relationship
model, Relational model, and write SQL queries.
Question Two
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.
Answer:
Learning
Outcome (3):
Create Entity-Relationship
model, Relational model, and write SQL queries.
2 Marks
Question Three
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.
Answer:
1 Mark
Question Four
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.
Answer:
please be careful of the note in the begininig and dont forgate the reference
Is a question and answer assignment and I need it done within 12 hours. Details
Is a question and answer assignment and I need it done within 12 hours. Details is in the attached docs
Q1. You will create an Entity Relationship model for a business case. 1)Read thr
Q1. You will create an Entity Relationship model for a business case.
1)Read through the following business case.
2)Create an Entity relationship model with the necessary entities, attributes, identifiers and relationships to capture the data.
All relationships should be labeled with verb phrases.
Use UML notation for this work.
Relationship lines should be straight and should not cross.
3)Write out two “relationship sentences” for each relationship using the format:
One
Purpose In this discussion board, you will post your answer to the question. You
Purpose
In this discussion board, you will post your answer to the question. You will also read and respond to other classmate’s postings. This is an excellent way for you to interact with your colleagues and to share your thoughts about the question answer in a critical way.
Action Items
Access the discussion forum for this assignment by clicking on the discussion forum title.
Click on “Create Thread.”
Enter a title for your question in the “Subject” line.
Type your response into the message field to the following discussion prompt:
1.Discuss the difference and application of Two Tier and Three Tier Client-Server DBMS Architecture.
2.Respond to two other classmates’ postings by critically reviewing your classmate’s answer and stating which points you agree or disagree with.
Submission Instructions
Post your questions and your answer to your classmates before 19/Sep/2023 @ 23:59
Grading Criteria (4 Mark)
2 marks: for your original post.
2 marks: for each response to another classmate posting (2 marks maximum)
*An example of unacceptable replies: “I agree with you”, “good post I like it”, “I think your post it good” or any similar are not acceptable replies.
You will need to install and use Microsoft SQL Server Express and Microsoft SQL
You will need to install and use Microsoft SQL Server Express and Microsoft SQL Server Management Studio (SSMS) for this course. You can download the latest versions of these free software products here:
Microsoft SQL Server Express
Microsoft SSMS
Before completing the Assignment, please watch the Unit 3 videos covering facets associated with physical database modeling. Navigate to the Academic Tools area of this course and select Library then Required Readings to access your texts and videos.Based on the established database design diagram and the data contained in the Movies Dataset:
Identify the elements to be included in the physical data model.
Using SQL Server Management Studio Designer tools, create the database.
Using SQL Server Management Studio Designer tools, create the tables (convert entity names to table names).
Using SQL Server Management Studio Designer tools, associate column names (convert attribute names to column or field names), datatype, and number of characters for each attribute (field).
Using SQL Server Management Studio Designer tools, establish the primary keys for each of the tables.
Using SQL Server Management Studio Designer tools, establish any foreign keys for each of the tables (here you are converting your relationships to foreign keys).
Create a screenshot of your SQL Management Studio showing the database and tables you have created; embed this screenshot into your Word document.
Please use the following guidance document to help you complete this assignment: Instructions for Using the Microsoft SSMS Designer Tools to Generate the Movies Database
You will need to use the established database design diagram and Movies Dataset for this assignment. Download and use the diagram and data for your analysis.
Assignment Requirements
Microsoft SQL Server Express and SQL Server Management Studio (SSMS) MUST be installed to complete this Assignment.
Compose your Assignment in a Word document and be sure to identify yourself, your class, and unit Assignment at the top of your paper. Embed the screenshots from SQL Server Management Studio showing the work performed for the creation of the database and tables.
Also review the university policy on plagiarism. If you have any questions, please contact your professor.
The assignment is due by the final day of the Unit 3 week.
You will need to install and use Microsoft SQL Server Express and Microsoft SQL
You will need to install and use Microsoft SQL Server Express and Microsoft SQL Server Management Studio (SSMS) for this course. You can download the latest versions of these free software products here:
Microsoft SQL Server Express
Microsoft SSMS
Before completing the Assignment, please watch the Unit 3 videos covering facets associated with physical database modeling. Navigate to the Academic Tools area of this course and select Library then Required Readings to access your texts and videos.Based on the established database design diagram and the data contained in the Movies Dataset:
Identify the elements to be included in the physical data model.
Using SQL Server Management Studio Designer tools, create the database.
Using SQL Server Management Studio Designer tools, create the tables (convert entity names to table names).
Using SQL Server Management Studio Designer tools, associate column names (convert attribute names to column or field names), datatype, and number of characters for each attribute (field).
Using SQL Server Management Studio Designer tools, establish the primary keys for each of the tables.
Using SQL Server Management Studio Designer tools, establish any foreign keys for each of the tables (here you are converting your relationships to foreign keys).
Create a screenshot of your SQL Management Studio showing the database and tables you have created; embed this screenshot into your Word document.
Please use the following guidance document to help you complete this assignment: Instructions for Using the Microsoft SSMS Designer Tools to Generate the Movies Database
You will need to use the established database design diagram and Movies Dataset for this assignment. Download and use the diagram and data for your analysis.
Assignment Requirements
Microsoft SQL Server Express and SQL Server Management Studio (SSMS) MUST be installed to complete this Assignment.
Compose your Assignment in a Word document and be sure to identify yourself, your class, and unit Assignment at the top of your paper. Embed the screenshots from SQL Server Management Studio showing the work performed for the creation of the database and tables.
Also review the university policy on plagiarism. If you have any questions, please contact your professor.
The assignment is due by the final day of the Unit 3 week.