Part 1- Introduction The report contains the...
ITDA1001 Database Fundamentals Assignments Help
Introduction of the subject
You have to make a MovieRewind database. The rights of the distribution of the movies are bought by MovieRewind from the owners of the copyright, and earn profits by producing and selling copies of the DVD of the movies by post.
Introduction of the assignment
Item in this assessment is related to the unit machine learning outcomes presented in the unit descriptors. This will test your level of understanding about the basic formation of the C# programming. In this assignment, you have asked to answer the short questions, E R Diagram need to be created, normalized tables, SQL statement need to be created in order to demonstrate your ability to use select, delete, update, create, alter, drop statement and prove your ability in order form views and methods.
Q1. Define DBMS. List few advantage of it? (2 marks)
Q2. What is weak entity? Explain it with example? (2 marks)
Q3. Notown Records has decided to store information about musicians who perform o its album (as well as other company data) in a database. The company has wisely chosen to hire you as a database designer (at your usual consulting fee of $2500/day). Draw E-R diagram for the following scenario: (6 marks)
All musicians that records at notown has an SSN, a name, an address, and a phone number. Same address is shared by the poorly paid musician, and each address should have one phone.
A unique identification number has been allotted to each instrument which is used in the recording of songs at Notown, a name (e.g., guitar, synthesizer, flute) and musical key (e.g., C, B-flat, E-flat).
A unique identification number has been allotted to th each album recorded on the Notown, a title, a copyright date, a format (e.g., CD or MC), and an album identifier.
A title and an author has been allotted to each song which is recorded at Notown.
One musician can play several instruments, and instruments allotted to several musicians can be played by them.
There are number of songs on each album, but one song will only be in one album.
Each song will be performed by one or more than one musicians, and number of songs may be performed by the musician.
There will be one producer in every album who is also a musician. Several albums may be produced by a musician, of course.
Q4. Give the third normal form based on below details:
Q5. Write SQL statement for following:
Retrieve a list of Northwind’s customer (names) who are in cities where there are no supplies.
All the product name should be listed which is from Sydney traders where the product’s unit price is greater than the average of all products unit.
All those cities have to be listed which has both Northwind’s suppliers and customers.
Challenges student might face:
Several students may face the challenges in the completion of ITDA1001 Database Fundamentals assignment such as defining DBMS, explaining weak entity, giving example of each and drawing ER diagram. With OZ Assignments, you get important academic and personal guidance and tutorial help in ITDA1001 Database Fundamental assignment help. Get feedback amendment without any additional cost.