DBLP (http://dblp.uni-trier.de) is a computer science bibliography database that keeps track of all computer science articles (papers) published in conferences and journals. It holds basic information about each paper, such as the title, the authors, the journal/conference where each paper appears, and so on. In this lab assignment, you are asked to design and create in Microsoft SQL Server at CSIL a simple database that models the DBLP data. Your database should be modelled to contain the following information: For each author, the database should keep the name and email address of the author. Each paper has a title, one or more authors, a short abstract, the year it was published, and the venue where it was published (the name of the conference or journal). Each paper cites other papers. Each venue has a name (typically not a single word) and an abbreviation for the name. For instance, the International Conference on Very Large Databases is abbreviated to VLDB, while Journal of the Association for Computing Machinery is abbreviated to JACM. All journals and conferences have unique names and abbreviations. A paper is only published once. Also, you should assume that a venue is either of type conference or journal. More specifically, you should accomplish the following tasks 1. Design a database schema to model the domain of computer science bibliography as described above. You can use as many relations as you deem necessary. Determine suitable data types for each attribute Specify the keys for relations. It is up to you to decide if there should be any keys, and which attribute (set of attributes) should form a key. Provide the definition of the schema in a simple text file named LastNameFirstNameSchemaDefinition.txt, where each relation is defined in the form RelationName (attribute_1 datatype, attribute_2 datatype, ..., attribute_7,. . .) Keys of RelationName: attribute_i, attribute_2), attribute_7). . . After defining the schema, include in the file LastNameFirstNameSchemaDefinition.txt a short paragraph explaining the schema you created. Focus on explaining what information each of the relations holds, how you chose the data types of the attributes, and how you picked the key constraints. The paragraph should be no longer than 200 words 2. Write the data definition commands for creating the schema you chose. The commands should generate the tables, as well as the key constraints 3. Insert at least 10 publications into your database using the INSERT INTO command Include the commands for tasks 2 and 3 in a text file named LastNameFirstNameSchema.txt