Relational Schema For Database And Database - 1816 Words

Question 1: Relational Schema (6 Marks) †¢ Provide a relational schema for the database you will create. †¢ Identify the primary keys (1 mark), the foreign keys (1 mark), and the constraints (1 mark). †¢ Identify the data types (1 mark) and write a query to create the database with MySQL (1 mark) and one to import the sample dataset you were provided with (1 mark) Answer 1: †¢ Provide a relational schema for the database you will create. Movies_n9000348 movieID Title Year Ratings_n9000348 reviewerID movieID rating comments Reviewers_n9000348 reviewerID name yearJoined trustRating †¢ Identify the primary keys (1 mark), the foreign keys (1 mark), and the constraints (1 mark). Listed below are the Established Relationships: - 1) movieID is the ‘Primary Key’ in the Movies_n9000348 table. 2) Combination of reviewerID and movieID is a ‘Composite Primary Key’ in the Ratings_n9000348 table. 3) movieID from Ratings_n9000348 table is the ‘Foreign Key’ to movieID column in the Movies_n9000348 table. 4) reviewerID from Reviewers_n9000348 table is the ‘Foreign Key’ to reviewerID column in the Ratings_n9000348 table. †¢ Identify the data types (1 mark) and write a query to create the database with MySQL (1 mark) and one to import the sample dataset you were provided with (1 mark) †¢ Identify the data types (1 mark) DATATYPES: Datatypes identified for the column variables in Movies_n9000348 table: 1) movieID: INT 2) Title: VARCHAR(100) 3) Year: INT DatatypesShow MoreRelatedAnnotated Bibliography On Non Relational Databases Essay1072 Words   |  5 Pagesof NoSQL databases has risen in the past decade as traditional relational databases cannot handle the vast amount of data as it was not designed to effectively manage such a large data collection. The following research paper gives an introduction to non-relational databases otherwise known as NoSQL. It defines what a NoSQL database is, the origins of its existence and the various types of NoSQL databases. It goes on to discuss the advantages and disadvantages of non-relational databases and the reasonRead MoreDifferent Data Models And Schemas907 Words   |  4 Pagesn of different data models and schemas a) Critically compare the following database types (schemas) Hierarchical Database Kind of database model which is designed in a hierarchy completely access to data beginning at the highest of hierarchical then changes to down such as customer to order. Also this system relation records together same a family tree that each record has just one owner. The hierarchical typical structure has levels which shows one –to – many also relationship between a parentRead MoreKey Features Of The Database Management System1035 Words   |  5 Pagesof the database management system MongoDB. Day-to-day information is growing in gigantic amount. Generated information include predominant information and it will have to be analyzed for gathering essential expertise. On the whole, relational databases are used so as to system the data. These, ways works successfully for small amount of knowledge. What if the data is very tremendous? To avoid this problems Mongo databases are introduced. MongoDB is a cross-platform document-oriented database. ClassifiedRead MoreDescription Of A Relational Database1366 Words   |  6 PagesNoSQL is the generalized term to describe a relational database that uses no form of SQL language querying and consists of several data models to define it. My topic of this research paper is the Document Store dat a model. I will be covering the introduction of the model and its mechanics, how and when the model emerged, its strengths and weaknesses, and it’s real world applications. Introduction and How it Works Document Store or â€Å"Document-oriented database† is a data model within the NoSQL familyRead MoreAnnotated Bibliography On Hierarchical Database902 Words   |  4 PagesHierarchical Database Kind of database model which is designed in a hierarchy completely access to data beginning at the highest of hierarchical then changes to down such as customer to order. Also this system relation records together same a family tree that each record has just one owner. The hierarchical typical structure has levels which shows one –to – many also relationship between a parent and children divisions. The main key this models which following by each parent can have many childrenRead MoreDatabase Questions Pg.80956 Words   |  4 Pagesto the relational model of data: Domain – Set of atomic (indivisible) values. Attribute – it describes a component of the database, such as a table or a field. N-tuple – in mathematics, an ordered set of n elements called its components or coordinates. Relation Schema – It is representation of database highlighting relationships that we have created. Relation State – set of tuples that have the same attributes. Degree of a relation – number of attributes n of its relation schema. RelationalRead MoreDocument Based Data Modeling Technique And Relational Technique1230 Words   |  5 PagesJanu Barot Database System Midterm Exam Document based data modeling technique and relational technique In todays era, the volume of data we manage has developed to terabytes. As the volume of data continues developing, the sorts of data produced by applications get to be wealthier than some time recently. Subsequently, traditional relational databases are tested to catch, visualize, seek, share, break down, and store data. We find many difficulties in managing bigRead MoreSecurity Of Nosql Database Against Intruders Essay1707 Words   |  7 PagesSecurity of NoSQL Database against Intruders Abstract The evolution of distributed web based applications and cloud computing have generated the demand to store voluminous of big data in distributed databases efficiently to offer excessive availability and scalability to users. The new type of database resolves many new challenges especially in large-scale and high concurrency applications which are not present in relational database. These new sorts of databases are not relational by using explanationsRead MoreDatabase Design1119 Words   |  5 PagesDatabase Design Scenario Currently a school uses a non-computerised database system to store the following information about its students: roll class, surname, first name, guardian s name, address, student s date of birth, gender, sport house, emergency-contact telephone number, mailing name, list of subjects offered, and subjects in which the student is enrolled. The system takes up a large amount of space, has many duplicated entries some of these with mistakes and it is time consumingRead MoreDatabase And Unstructured Data Of A Business Perspective1001 Words   |  5 Pagesmore on exploring semi structured and unstructured data that is generated through social media activities, personal media information and geo location data. NoSQL database is a type of database that provides a means for storage and retrieval of structured, unstructured and semi-structured data. This is different from relational databases which uses the tabular relation. From a business perspective, considering the NoSQL is said to have a considerable advantage over the others. More importantly, since