Database Design – ITS113Assignment – Asset Management systemThis assignment puts you in a hypothetical, but realistic, scenario where you work on databasedesign intended to support the needs of an organisation. The assignment is divided into threeparts which are intended to reinforce the iterative methodology used in a typical project. The firstpart is an individual effort; each student will work on their own to develop the first draft of thedesign. The second and third parts will be a group effort, where students will collaborate ingroups of no more than four, to deliver a more substantial body of work that builds on part one.DeliverablesThe assignment should be delivered as two components: Entity relationship model document – This component should be delivered as a single file.The preferred format is PDF, however Libre Office or Microsoft Office files are alsoacceptable. MySQL database – This component should be delivered as a MySQL dump file, exportedfrom your database.Both of these components should be uploaded to the Moodle assignment page as separate files.Entity Relationship Model DocumentThis document should capture the business rules, based on your understanding of the providedinformation. You will need to identify the entities involved and create external model(s) thatshow their relationships. Use a combination of descriptive text and entity relationshipdiagrams. You should document the assumptions you make and write down your reasoningwhen faced with design choices that are not straight forward.The information provided in the scenario is far from exhaustive and a process of discovery will berequired to gain a better understanding. Some provided information may not be directly relevantto the design of the database. You will have the opportunity to ask questions during tutorials. Youcan also do your own research to discover how real world organisations operate. Yourdocumentation should capture this discovery process. One way of doing this is to provide properattribution for the sources of your information.Page 1 of 3MySQL DatabaseSelect one of the external models you produced above. This model should have at least threeentities and three relationships. Convert this external model into an internal model andimplement this as a MySQL database schema. Your database should be populated with enoughsample data to demonstrate how it works. All tables should have data – approximately three tofive rows per table should be sufficient.Export the MySQL database into a MySQL dump file. This can be achieved from MySQLWorkbench, using the Server/Data Export menu item. You should generate an SQL dump withthe following settings: Select: All objects in the schema Select: Dump Structure and Data Select: Export to Self-Contained File Enable: Create Dump in a Single Transaction Enable: Include Create Schema In advanced options: Enable: complete-insert Disable: extended-insertThe ScenarioYou are a part of a team that has been given a contract to provide visual effects for a number ofscenes in a big budget movie. The movie production company will be on a tight schedule andwant a streamlined system for digitally handling almost all interaction with your newly formedcompany. You have been tasked with the design of a database that will support an assetmanagement system. Time is of the essence, so the strategy is to come up with the simplestpossible system that will support the workflow. The design should be future proof so thatadditional features can be added as needed, without causing disruptions or data loss.The shots you will be creating involve the addition of computer generated characters into liveaction scenes. The expected workflow is as follows: You will be supplied with raw camera footage from each shoot. Besides the video, the raw camera footage also contains metadata, such as the lens used,zoom, aperture, shutter speed, etc. There will be additional information available for each shot, such as distance to camerafor key elements, cast / characters, locations and colour temperature of studio lights, etc. Each set will have a 3D file supplied that provides a rough model of the set. This can beused to project backgrounds onto the set when compositing. Each shoot will be referenced by a scene number and within each scene there will beseveral shots. Some shots can have multiple takes. The footage will all be green screen studio shots, with some props placed in the scene.Page 2 of 3? Typically each shot will consist of a take of the scene only, without any actors and alsomatching takes with the actors. All related takes will be done using motion controlled camera movement. You will be supplied with the motion control data. There should be a person-in-charge for every asset, who will have responsibility for thatitem. They should always be reachable via email and on at least one phone number, butthe system should store any additional contact information available. Any props that were used on set and will require to be animated will be packaged andshipped to you. Each physical prop will have an embedded NFC tag that uniquely identifies the asset. When the NFC tag is read, it will produce a 64 character string. Props will need to be scanned to generate 3D models and texture maps. Once props are digitised, they need to be shipped back promptly. The movie production company wants the NFC tags scanned as soon as the props arriveand also when they are sent back, to track the custody of these assets. Your company will have to create the remaining elements required for each shot andcomposite them. These elements will usually be: background matte paintings, mapped onto 3D scene geometrycomputer generated characters, animated using motion capture data rendered props, based on 3D scans and animated using, physics emulation, particlesystems or motion capture, as required In order to be able to work efficiently, you want to be able to see all the assets that arerequired in a shot or a scene. Shots and scenes need to be prioritised, so that there is clear visibility of what needs to bedone first. The final deliverable is a number of scenes, each comprising of one or more shots. Eachshot will be delivered as a sequence of rendered frames. The director expects to be able to see work-in-progress, which will be the latest testrender for each shot. To get the maximum use of the render farm, any shot that has had an update since thelast test render should be flagged as needing a new test render.Some assumptions you can make: The database does not need to store the data itself. You can assume that the data will bestored on a network and available to all who require access. All files can be accessed usinga URI. In most cases, your system does not need to understand the content of the files, howeverit should be possible to assign categories to files so that they can be correctly classified asthe right kind of asset.Page 3 of 3本团队核心人员组成主要包括BAT一线工程师，精通德英语！我们主要业务范围是代做编程大作业、课程设计等等。我们的方向领域：window编程 数值算法 AI人工智能 金融统计 计量分析 大数据 网络编程 WEB编程 通讯编程 游戏编程多媒体linux 外挂编程 程序API图像处理 嵌入式/单片机 数据库编程 控制台 进程与线程 网络安全 汇编语言 硬件编程 软件设计 工程标准规等。其中代写编程、代写程序、代写留学生程序作业语言或工具包括但不限于以下范围:C/C++/C#代写Java代写IT代写Python代写辅导编程作业Matlab代写Haskell代写Processing代写Linux环境搭建Rust代写Data Structure Assginment 数据结构代写MIPS代写Machine Learning 作业 代写Oracle/SQL/PostgreSQL/Pig 数据库代写/代做/辅导Web开发、网站开发、网站作业ASP.NET网站开发Finance Insurace Statistics统计、回归、迭代Prolog代写Computer Computational method代做因为专业，所以值得信赖。如有需要，请加QQ：99515681 或邮箱：99515681@qq.com 微信：codehelp
网友评论